Conditional formatting applies only under certain conditions. For example, in a report you may only want:
- customer balances printed in red if they are past due
- dates to appear in Day, Month, Year format if the customer is Canadian
- background color to appear on every other line
You specify conditional formatting using formulas. When a conditional formatting formula is set up, the formula overrides any fixed settings you have made in the Format Editor. For example, if you select the Suppress option, and then set up a conditional formula for the Suppress option, the property will still apply only if the condition in the formula is met.
You are able to set "on or off" properties and attribute properties conditionally. However, each of these types of properties requires a different kind of formula.
To add conditional formatting to an object
- Right-click the object, and select Format.
- Click the appropriate Formula button located on the right side of the dialog box.
- In the Format Editor dialog box, enter the formula.
- Click Save and close.
- If there is an error in the formula, a message box appears, asking whether to exit without examining the error. If you click No, a second message box will be displayed, detailing the error.
- If there is no error in the formula, you are returned to the Format Editor. Note that the Formula button has changed. This indicates that a formula has been entered for that property.
- Click OK to return to your report.
See Also
Conditional On or Off Properties | Conditional Attribute Properties