Change color of control using data in another contro, this is for an access report.

[n2mee]

Hello,



I know you can use a "Conditional format" to change a color of a control in a report. What I am trying to do is change the whole line if a condition yields "True" of one control. I did it once before, but oops I didn't save my work. I am using the format [Entity]![IT]. Where "Entity" is either the department or vendor, and "IT" is for the IT department. I want the control "Name" to change color if "Entity" is true if "IT" is the data.

Thank you,

Scott

[RuralGuy]

If this thread is truly Solved, do you care to post your solution?

[n2mee]

Sorry RuralGuy,

It is a little embarrassing, the formula is...

The condition is "Expression is" & the formula is [Entity]="IT"

Then you choose the fill, color or font.

[RuralGuy]

Thanks for posting back with your solution.