Changing a field name in the query design grid changes the column heading in query Datasheet view. In addition, if you create a new object, such as a new form, report, or data access page, based on the query, the new object uses the new field name. For example, if you create a control to display the renamed field, the new field name will be used for the control name and its label caption. The field name in the underlying table doesn't change, however, nor does it change in forms and reports that were based on the query before you changed the field name.
Note Changing a field's name in the current query's design grid has no effect in the query's Datasheet view if the Caption property for that field has been set in the underlying table or query.
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.
Return to Change a field name in a query