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