How to: Specify Captions for Fields

JavaScript Editor js editor     Web development 

Main Page

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.

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

  1. Open the database containing the table.

  2. Open the table in the Table Designer.

  3. On the Fields tab, select the field that you want.

  4. In the Caption box of the Display area, type the text for the field caption.

    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:

В Copy Code
DBSETPROP('Supplier.Fax', 'Field', 'Caption', 'Supplier_Fax')

See Also

JavaScript Editor js editor     Web development