The condition: fewer than 40. The formatting: heavy yellow numbers on a black background.
Imagine how convenient it would be, if Access knew which data mattered most to you, and brought it to your attention when you needed it. Conditional formatting is almost like that.
You can specify data values that will change the appearance of a control if the specified condition applies. When the number of units in stock drops below a set amount, for instance, that control catches your eye with the information.
To apply conditional formatting, you would select a control in Design view. Then, on the Format menu, you would click Conditional Formatting to open that dialog box.
The dialog box shows you the control’s formatting as it appears before any conditional change is applied. It also provides options and data fields for specifying a condition and the difference you want it to make. You can apply as many as three conditions and formats to a control. You’ll get a chance to try conditional formatting in the practice session for this lesson.
Note You cannot apply conditional formatting to controls on a data access page.