Get value of 10 textboxes to decide group footer color

[lanm]

If I have the 10 textboxes in my footer with a value of "X" (from an IIF() expression), then I would like to alert the users and have the footer a different color.

I'm trying to get the value of the textbox, but keep getting an error of it being undeclared. I'm trying different syntax, but can't get it to work.

Here's the code:
=
IIF(
textbox11 ="X" or textbox15="X" or textbox19="X" or textbox27="X" or textbox23 = "X" or textbox31 = "X" or textbox35 = "X" or textbox39 = "X" or textbox43 = "X" or textbox47 = "X"
,"Gainsboro","Transparent")

 

[lanm]

No need anymore!

Thanks!

 

[Catadmin]

Even though you don't have need of this answer, I thought I'd post this for everyone who isn't aware of it.

Transparent is NOT a valid color. I don't know why Microsoft has it set up that way except that it is an indicate that it will use the background color of the report body instead of another color. You have to use Nothing instead, or white if your report background is white.



Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???