Changing Color Attributes for a Control Dynamically

J

Jim

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!
 
K

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I change color attributes? 0
Change text box background color depending on value in Label Reports 0
Conditional Color Formating 1
Access 2002 change report header text 0
Radical color chages on importing a worksheet (Excel 2010)? 0
Changing text color and textbox color on Access Report 1
A real doozy 3
change the background color of a cell in access 2010 5

Top