js editor
Web development
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:
| В |  Copy Code |
|---|---|
DBSETPROP('Supplier.Fax', 'Field', 'Caption', 'Supplier_Fax') | |