graphic2
graphic1

Exam 77-424: Microsoft Access 2013
5.0 Create Reports
5.2 Set Report Controls: Use Conditional Formatting

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...

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