Changing Field and Column names
(a/k/a “Aliasing” field names)
Using the Field’s “Caption” Property
to Change what is Displayed as the Column Name

<Back>

Examples

Usually, the field name is used for the column name :
In this example, “StudentNo” is both the field name and also the column name,
which is displayed at the top of each column of fields.

However, the name of the column that is displayed
can be changed to something other than the field name,
using the field’s “Caption” property :

In the table’s “Design” view, select the field you want to display a different name.

In the “Filed Properties” (lower section), select the “Caption” property.

Type in what you want displayed instead of the actual name of the field.

Note that this will not change the name of the field,
just what is displayed at the top of the column in the table’s “Datasheet” view.

Save the table.

Now the column name that is displayed is the new “Caption” for that field :

The field name is still “StudentNo” but the column name displayed has changed.

<Back>