The display format for a column.
Format on the Format page in the Properties view.
A string specifying the display format.
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')
Edit 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.