How to: Specify Captions for Fields
For database tables, you can specify and display a caption instead of the field name in the column header of a browse window or grid. The caption can be text or an expression.
Note
Expressions cannot exceed 254 characters. If the expression exceeds 254 characters, the caption defaults to the field name.
To specify a caption for a field
Open the database containing the table.
Open the table in the Table Designer.
On the Fields tab, select the field that you want.
In the Caption box of the Display area, type the text for the field caption.
Tip
To specify an expression for a field caption, include an equal sign (=) preceding the caption string.
For more information, see Fields Tab, Table Designer.
To specify a caption for a field programmatically
- Use the DBSETPROP( ) function with the Caption field property.
For more information, see DBSETPROP( ) Function.
For example, the following code specifies the caption "Supplier_Fax" for a field named Fax in a supplier table:
DBSETPROP('Supplier.Fax', 'Field', 'Caption', 'Supplier_Fax')
See Also
Tasks
How to: Open Databases
How to: Edit Table Structure