Access Tip -  Report conditional formatting

You can configure conditional formatting to automatically highlight areas of your report when it meets certain conditions. For example, let's say you want Access to display all donations $100 and above in white letters on a red background in your Annual Appeal Donation Report.

 Follow these steps:

1. Create a report that includes the Donation Amount field.

2. In Design view, select the text box control for the field.

3. Go to Format | Conditional Formatting.

4. Under Condition 1, select Greater Than Or Equal To from the second drop-down list.

5. Enter 100 in the text box.

6. Select red from the Fill/Back Color drop-down box.

7. Select white from the Font/Fore Color drop-down box.

8. Click OK.

When you run the report, Access will format all donation amounts $100 or above as you've indicated