• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Hour 4. Forms Introduced > Using the Conditional Formatting Feature of a Form

Using the Conditional Formatting Feature of a Form

At some point you might need to have a control stand out if it meets certain criteria. You can add formatting to the control to set what condition should be met in order for a particular type of formatting to appear in the record. An example would be for the inventory amount to appear in red if the inventory amount is less than the reorder amount. Here's how you use this Conditional Formatting feature:

1.
Open the form that you want to format in Design view.

2.
Click in the control that will contain the conditional formatting.

3.
Choose Format | Conditional Formatting. The Conditional Formatting dialog box appears (see Figure 4.23).

Figure 4.23. The Conditional Formatting dialog box.


4.
Select the condition (equal to, greater than, and so on).

5.
Type the appropriate criteria.

6.
Select the desired formatting.

7.
Click OK. Access applies the conditional formatting expression.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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