Changing Color Attributes for a Control Dynamically

[Guest]

Looking for help with a color setting on a report.

I'm designing a report in which the background & foreground colors for a
single control need to change based on a database / query produced value.

Each record in the query contains the background & foreground numbers that I
want a specific control to use when printed. For example, green = 44544.

How can I get ACCESS to change these attributes dynamically?

My database is running in Access 2000.

Thanks in advance for any help. I had it figured out approx 2 years ago,
and forgot how I did it! This "getting old thing" is for the birds!

 

[Ken Snell \(MVP\)]

Use the Format event of the section of the report that contains the control
to run VBA code that assigns the backcolor and forecolor properties for that
control.