Conditional Format based on different field

[Ebes1099]

I have a report that shows all the records (Each record is a group) in a table with one field being Percent Increase. There's an option for the user to enter a custom increase or check a box to use the default increase when the input groups on a form.

The report shows the data for each group and the Revenue increase is blank on groups where the default is used because that's stored in a different table. So when you look at the report that field is blank and it could be confused for missing data. I do show in another column the default is being used but it would be nice if I could color that cell on the report to be different if the default is being used just so it's easy to recognize right away that it's not missing data, its just using the default.

So is there a way to check the field called "Use Default" and if it is using that, then make the field "Percent Increase" a different color?

 

[dhookom]

With Conditional Formatting, you can set the format of one control based on an expression referencing another control. You would change the Condition from "Field Value Is" to "Expression Is".

Duane
Hook'D on Access
MS Access MVP