Color Coding Lines

S

Sondra

I have a query that I use to generate a report. I want to know if there is a
way to create an IIF statement to color code the lines in the report.

For example IIF (fld_SOPType)=BHQ, RED, BLUE)

Can someone help to let me know if this is at all possible?

I know that there is conditional formatting in the report, but I want to
make the entire line the necessary color, not just the field.

Please advise.
 
R

Rick B

Entire line as in the background? Or each control on the line?

If it is each control, then simply apply the conditional formatting to each
control on the line. Conditional formatting can be based on the entry in
another field by using the "formula".
 
Top