Use Conditional Formatting

Conditional Formatting changes the Font Color of the Control depending on the Rules that you set up. You can use Conditional Formatting in a Report as well as in a Form.


This Rule will be applied to the Rating data, as we did earlier on the MovieSearchSubform.


2. Try it: Use Conditional Formatting

The Report is still open in Design View.

Select the Rating Control in the Detail Section.

Go to Report Design Tools->Format.

Go to Control Formatting.

Click on Conditional Formatting.


What Do You See? The Conditional Formatting Rule Manager will prompt you to create a New Rule.


Keep going...

Exam 77-885: Microsoft Access 2010

5. Designing Reports

5.4. Apply Report Format options: Use Conditional Formatting

Report Design Tools->Format->Control Formatting->Conditional Formatting