Display formats you assign to a column in the Database painter are used by default when you place the column in a report or form. You can override the default format in the Report painter or Form painter by choosing another format from the extended attribute system tables or defining an ad hoc format for one specific column.
About computed fields
You can assign display formats to computed fields using the
same techniques as for columns in a table.
To specify a display format for a column in the Report painter or
Form painter:
In the Report painter or Form painter, move the pointer to the column, select Properties from the column’s pop-up menu, and then select the Format tab.
Information appropriate to the datatype of the selected column displays. The currently used format displays in the Format box. All formats for the datatype defined in the extended attribute system tables are listed in the pop-up list (displayed by clicking the button).
Do one of the following:
Delete the display format.
Select a format in the extended attribute system tables from the pop-up list.
Create a format for the column by typing it in the Format box. For more information, see “Defining display formats”.
Format not saved in the extended attribute system tables
If you create a format here, it is used only for the current
column and is not saved in the extended attribute system tables.
Shortcuts in the Report painter
To assign the Currency or Percent display format to a numeric
column in a report, select the column, then click the Currency or
Percent button in the PainterBar or select Format>Currency or Format>Percent
from the menu bar.
You can add buttons to the PainterBar that assign a specified display format to selected columns in reports and forms.
For more information, see “Customizing toolbars”.