Format

Description

The display format for a column.

In the painter

Format on the Format page in the Properties view.

Values

A string specifying the display format.

Example

The following statement, when applied to the Format property of the Salary column, causes the column to display the word Overpaid for any salary greater than $60,000 and Underpaid for any salary under $60,000:

If(salary>60000, 'Overpaid', 'Underpaid')

NoteEdit style consideration Typically you would have an Edit Mask edit style assigned to a salary column. Because edit styles take precedence over display formats, the strings Overpaid and Underpaid will not display in the salary column in the preceding example unless you also change the assigned edit style from Edit Mask to Edit, or select Use Format on the Format page of the Properties view.