Using Expressions in Styles

Style expressions override any default options selected. Only specific words are recognized as style expressions. See Using Style Rule Expressions in the Form Editor for a list of acceptable words.

After adding a control to a form (within the Form EditorThe editor in which you edit forms.), click the down arrow in the Style Rule field, and the Expression Editor appears.

Style Rule Field in a Control

See Using Forms for information about the Style Rule field.

Enter an expression to apply to this style, if needed. You can define what existing style (bold, header, etc.) to apply to a control based on a condition. See Constructing Expressions for more information.

For example, enter the following expression into the Style field of a grid:

$(iif((Status == "Closed"), "RedStyle", "LimeStyle"))

This returns the row as "red" if the record status is closed and returns the row as "lime green" if it is not closed.