Any
object based on a query displays the field names used in
that query. For example, all reports and forms based on a
query with a field named ADDR1 will also show ADDR1 for that
field's label or header.
Rather
than changing the field's label as it appears in each object
derived from the query, you can use the field's Caption
property to change it once in the query design grid.
Follow
these steps:
-
Right-click the field name in the query design grid, and
select Properties.
-
On
the General tab, enter a name in the Caption text box.
The name
in the Caption text box now appears as the field's heading
in the query's Datasheet view. All objects based on that
query will also display the Caption property as the field's
label or heading.
