troubleshooting Question

Change Back Color of Rectangle in Query

Avatar of ttist25
ttist25 asked on
Microsoft AccessSQL
7 Comments2 Solutions468 ViewsLast Modified:
Hello,

I have a microsoft access 2007 database with a report fed by a query.  I'm using iif statements to get values from the record and display text in text fields.

I would like to also use iif statements to change the Back Color of a rectangle on my report based on the value of a field.  

Here's an example of what I'm doing to display text:

iif(myTable.MyField_Description = "Value1",
"Text for value1.",
"Text for everything else.")
AS myTextBox,

That will display the appropriate text in myTextBox.

I would like to use the same thing to change the back color of a rectangle but I'm not sure of the syntax.  It would be something like this:

iif(myTable.MyField_Description = "Value1",
my.Rectangle.BackColor="#000000",
my.Rectangle.BackColor="#FFFFFF")
AS myRectangle,

FYI - if you haven't figured it out by now, I need to point out that I'm a serious noob with this stuff.  

TIA!
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 2 Answers and 7 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros