How to Copy One Microsoft Access Field Definition to Another Field

Copying a field definition ensures that your new field will be identical to the original, which can save some time. These instructions apply to MS Access 97. Procedures for other versions may vary.

Instructions

Difficulty: Easy

Things You’ll Need:

• Microsoft Access

1. Open the field in Design view.
2. Select the field that you want to copy.
3. Click the Copy icon on the toolbar, or use open the Edit menu and choose Copy.
4. Click in the first empty row.
5. Click on the Paste icon on the toolbar, or use the Paste command from the Edit menu.
6. Name your new field.
7. Save the table.

Tips & Warnings

• To select one field, you can click in the Row Selector, which is the small (usually gray) box to the left of the field name.
• If you want to select a group of fields, you can drag through the row selector to the immediate left of those fields.
• Copying a field definition copies only the definition. It does not copy the content.

Who Can Help:

• Find Computer, Electrical and Telephone Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.
• Find Electrical Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.