Access 2007: Conditional Formatting

Access 2007: Conditional Formatting

Conditional Formatting allows you to automatically change the formatting of data displayed on individual controls based on the contents of that control. Conditional Formatting works well when you want to highlight specific data. For instance, you may want to highlight all negative numbers with red text.

Each control can store up to three different conditional formats.

Applying Conditional Formatting

View the form in Layout View

Choose the Conditional command in the Font group on the Form Layout Tools Formatting Contextual tab

Figure 61. Conditional Formatting Dialog Box

3.Set your condition parameters

4.Click Add to add another condition

5.Click OK when complete

Deleting Conditional Formatting

View the form in Layout View

Choose the Conditional command in the Font group on the Form Layout Tools Formatting Contextual tab