1-866-245-5224 sales@keystonelearning.com

Access 2003: Conditional Formatting

Access 2003: 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
     
  1. View the form in Design view
     
  2.  
  3. Select the field control for which you want to apply Conditional Formatting
     
  4.  
  5. Choose Format: Conditional Formatting from the Menu bar
     

Figure 61. Conditional Formatting Dialog Box

 

   4.      Set your condition parameters

   5.      Click Add to add another condition

   6.      Click OK when complete

Deleting Conditional Formatting

   1.      View the form in Design view

   2.      Select the field control for which you want to remove the Conditional Formatting

   3.      Choose Format: Conditional Formatting from the Menu bar

   4.      Choose the Delete button

 

Figure 62. Delete Conditional Formatting Dialog Box

 

   5.      Select the Condition check box(es) you want to delete

   6.      Click OK