Conditional Formatting w/Multiple text boxes

[John Kreps]

(acc 2002)

I've got six unbound text boxes on a subform that has a white
background. Each of those six boxes has an expression that when true,
will change its background from white to another color. These text boxes
need to go behind a single line of other bound text boxes (which show
the actual record). I.e., the purpose of the unbound text boxes
w/conditional formatting is to highlight the record/background with one
of six colors.

The problem is I don't know how to stack all the unbound text boxes
behind each other without hiding each other. The background can't be
transparent since that is what the conditional format changes.

Anyone have any suggestions as to how I can hide/show a text box stack
on others? (I've tried "send to back" which will not work due to the
unbound text box's non-transparent background).

John

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Fredg]

You don't need to use those extra controls to change the back color of the
control's that contain the data.

If you have Access 2002, use the control's conditional formatting property.

Select the data control.
Click Format + Conditional Formatting.
Set the Condition 1 drop-down box to
Expression Is
Write the expression in the text box along side the
drop-down (do NOT use the = sign).
Set the back color to whatever you want.
Save the change.
Do the same for each control.
--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.
"John Kreps" <de***********@deletethiskreps.mailsnare.net> wrote in message
news:3f***********************@news.frii.net...

(acc 2002)

I've got six unbound text boxes on a subform that has a white
background. Each of those six boxes has an expression that when true,
will change its background from white to another color. These text boxes
need to go behind a single line of other bound text boxes (which show
the actual record). I.e., the purpose of the unbound text boxes
w/conditional formatting is to highlight the record/background with one
of six colors.

The problem is I don't know how to stack all the unbound text boxes
behind each other without hiding each other. The background can't be
transparent since that is what the conditional format changes.

Anyone have any suggestions as to how I can hide/show a text box stack
on others? (I've tried "send to back" which will not work due to the
unbound text box's non-transparent background).

John

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[John Kreps]

I don't believe I can utilize the condition formatting "wizard" in
Access 2002 since I have more than 3 conditions...I have six, which is
why I created six text boxes each with its own expression. I just can't
get the "highlighting" textbox to show from behind the other 5.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!