Change text box background color depending on value in Label Reports

H

harrissteinman

Hi, hope someone can help. Struggling with this.

I have designed in MsAccess 2007 a Reports to print Labels 3 across.

I would like a specific field to change background color according to the value of the field. Using Conditional formatting, I can enable this but only for three values. However I am using more than 3 values.

In other words, if the value of the text box is "Milk", the text box background should be yellow; if "Wheat", should be red; if "Egg", should be green; etc. Is this possible or have I been wasting my time!

Harris
 

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

Can't change Background color on all reports 0
Change the font color/background of a text box depending on value 6
How do I change background color of Text Box based on condition? 1
add color in report depend on data value 5
Dropdown list values in color 0
Color cell depending on it's previous value 4
color coding values 0
Change Form Background Color 2

Top