Conditional Formatting in Reports

[Neal]

I am trying to conditionally format records in my reports and forms. I have calculated percentages in these reports that I want to change color/bold if the percentage is more than 5% off. I know that I can change the ForeColor in the control's property sheet, but can't find where to insert my IF statement. I have looked into macros and know I can insert an IF statement there, however, changing color/bolding is not an action option. Please let me know the easiest way to accomplish changing a group of selected record's font colors in a report or form.

 

[Rosco]

With your form or report in design mode,select the control to format conditionally, and go to the format menu and select conditional formatting

Hope this help
Rosco

 

[Neal]

Thanks for your response...How do I "select the control to format conditionally"

Thanks again,
Neal

 

[Averil Pretty]

Hi Neal,

When in design view:

1. click on the field you want this formatting on
2. click on Format menu
3. click on Conditional Formatting
4. type in your first condition
5. click add>> (you can keep adding from this point)
6. click OK

The other way to get to the Conditional Formatting screen
is to right click on the field and select Conditional
Formatting.

Hope this helps. No need to use IF statements

Regards,
Averil