• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Conditional Formatting

Access 2000 introduced conditional formatting, which displays data meeting specified criteria differently than it displays data meeting other criteria. For example, you can display sales higher than a certain amount in one color and sales less than that amount in another color. To conditionally format data displayed within a control, follow these steps:

1.
Select the control you want to conditionally format.

2.
Select Format, Conditional Formatting. The Conditional Formatting dialog appears.

3.
Select Field Value Is, Expression Is, or Field Has Focus from the first combo box.

4.
Select the appropriate operator from the second combo box.

5.
Enter the values you are testing for in the text boxes that appear on the right.

6.
Select the special formatting (bold, italic, background color, and so on) that you want to apply when the conditional criteria are met.

7.
Click Add to add additional formats.

8.
Click OK to apply the conditional formatting.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint