Note Changing a field's name in the current query's design grid has no effect in query Datasheet view if the Caption property for that field has been set in the underlying table or query.
- Open a query in Design view.
- Place the insertion point to the left of the first letter of the field name in the design grid.
- Type the new name followed by a colon.
Note If you're replacing the field name Expr1 (or Expr2, and so on) that Access automatically assigned, replace only the name, not the expression that follows the colon.
If you want the new field name to be used only for datasheet columns, or label captions in forms, reports, and data access pages, you can set the Caption property for the field instead of renaming the field in the design grid.
Change a field's caption- Open a query in Design view.
- In the design grid, click anywhere in the column of the field whose caption you want to change, and then click Properties
on the toolbar. - In the Caption property box, type the new caption for the field.