Change a field name in Design view

Change a field name in Design view

  1. Open the table in Design view.

  2. Double-click the field name you want to change.

  3. Type the new field name, following Microsoft Access object-naming rules.

  4. Click Save on the toolbar to save your changes.

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