Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Change text box background color depending on value in Label Reports
61 views
Skip to first unread message
harriss...@gmail.com
May 13, 2013, 5:29:59 PM5/13/13
to
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
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
0 new messages