More than 3 conditins -conditional formatting [Closed]

Report
-
Posts
1021
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
-
Hello,

I have developed a report in access 2007 and I want to format a textbox backcolor based on colors Red, Blue, Green, Yellow and Orange. The control is textbox on report and control source is a field from querry that fetches color status from database.

Please let me know how can i achieve this.

1 reply

Posts
1021
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
182
have you tried looking at the formatting using icon sets. there is one there for 5 colours.

could you give an example of the data and conditions that you are trying to work with.

unless of course you find the solution in the icons rules.
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!