Change a field name in Datasheet view

1. Open the table in Datasheet view.
   
   
2. Double-click the field selector of the field that you want to change.

   Note   If the Caption property has been set for this field, the text displayed in the field selector may be different from the actual field name. In this case, when you double-click the field selector, the caption text will be cleared and replaced with the field name. If you continue, you'll be editing the field name, and when you press ENTER to save this change, the caption text will be deleted. If you don't want to delete the caption text, press ESC immediately after double-clicking the field selector to cancel editing. For more information on using the Caption property, click .

3. Type the new field name, following Microsoft Access object-naming rules.
   
   
4. Press ENTER to save the new name.

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.