O'Reilly logo

Microsoft® Office Access™ 2007 Plain & Simple by Curtis D. Frye

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required