Rename a field in a table or datasheet

If the Caption property has been set for a field, the text displayed in the field selector might be different from the actual field name. If you rename a field with a caption while in Datasheet view, the caption will be deleted and replaced with the field name. To avoid deleting a caption, rename the field in Design view.

Rename a field in a table in Design view

Important   If you have expressions or Microsoft Visual Basic for Applications code that contains references to a field whose name you are changing, you must update all of those references to the new name.

1. Open the table in Design view.
2. Double-click the field name you want to change.
3. Type the new field name.
4. Click Save on the toolbar to save your changes.

Rename a field in a table in Datasheet view

Important   If you have expressions or Microsoft Visual Basic for Applications code that contains references to a field whose name you are changing, you must update all of those references to the new name.

1. Open the table in Datasheet view.
2. Double-click the field selector of the field that you want to change.
3. Type the new field name and press ENTER to save it.

Change the field (column) name that appears in a datasheet

1. Open the table in Design view.
2. In the upper portion of the window, click the field for which you want to define a different column name.
3. In the lower portion of the window, click the Caption property box, and then type the text for the column name. The text can contain any combination of letters, numbers, spaces, and symbols up to 255 characters in length.