Administrator: The Reporter Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19

Format ->Conditional Formatting

 

Conditional Formatting

Adding Conditional Formatting to a Microsoft Access Report is the same as Formatting in Excel.

 

Try it: Format the Control

1. Select the Rating column

Go to Format->Conditional.

You should see the Conditional Formatting window.

 

2. Edit the Conditions

Condition 1 is equal to R.

Format the text Bold and Red.

 

Click OK and look at the report.

 

 

  Microsoft Access 2007 Exam 77-605 Topic: 2. Creating and Formatting Database Elements 

  2.7. Modify the design of reports and forms       

  2.7.6.   Apply and change conditional formatting on controls