Copy a field and its properties

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.

    1  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.