Changing Color Attributes for a Control Dynamically

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jim - 30 Sep 2007 22:32 GMT

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!

Signature

Jim

Reply to this Message

Ken Snell (MVP) - 30 Sep 2007 23:01 GMT

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.

Signature

Ken Snell
<MS ACCESS MVP>

> Looking for help with a color setting on a report.
>
[quoted text clipped - 11 lines]
> 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!

Reply to this Message