Microsoft® Office Access™ 2007 Plain & Simple

Applying Conditional Formatting

Changing the appearance of your form and report data by applying formats (or AutoFormats) makes your data easier to read. However, you may want to apply different formats to a control’s contents based on the data’s value. For example, you might want to highlight the names of any customers who are within 10 percent of their credit limit or display information about discontinued products in red.

Define a Conditional Format

1. Open a form or report in Design view.

2. Click the control to which you want to apply a conditional ...