Changing Color Attributes for a Control Dynamically

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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.
 
Back
Top