Access 2002 Programming by Example

Conditional Formatting

Conditional formatting enables you to change the format of a control in a form or report based on the value of the control. If you want to change a control’s color to red when its value exceeds 2,000, you can do that using conditional formatting. In the old days, before the conditional formatting function was added to Access, it was handled through code. You no longer have to be a programmer to take advantage of this feature. The following steps guide you through adding conditional formatting to a report:

1.	While in the Music Store database, open the Inventory Practice report in Design view.
2.	Click the UnitPrice text box.
3.	Click Format, Conditional Formatting from the menu, or right-click and choose Conditional ...