Show All

Copy a field and its properties (MDB)

Note  The information in this topic applies only to a Microsoft Access database (.mdb).

This procedure only copies a field's definition; it doesn't copy any values in the field.

1. Open a table in Design view.
2. Select the field or fields you want to copy.

   To select one field, click that field's row selector.

   To select a group of fields, drag through the row selectors of those fields.

   

   Row selectors

3. Click Copy on the toolbar and then click in the first blank row.
4. Click Paste on the toolbar.
5. Type a new name for the copied field.