FieldName Property

Applies To

Table Fields.

Description

You can use the FieldName property to specify the name of a field within a table. For example, you can specify “Last Name” for a field that stores employees’ last names within the Employees table.

Setting

Enter a field name, following Microsoft Access object naming rules. The name can’t duplicate any other field name in the table.

Note Avoid specifying a name for a field that could cause a conflict with built-in Microsoft Access function or property names, such as the Name property.

You can set this property in the upper portion of table Design view or using Visual Basic.

In Visual Basic, use the Data Access Object’s Name property to read and set a table’s field name.

Remarks

Microsoft Access identifies a field by its field name. Once you have specified a field name in table Design view, you can use that name in expressions, Visual Basic procedures, and SQL statements.

See Also

Caption Property, Name Property (Microsoft Office 95 Data Access Reference).