467,156 Members | 979 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,156 developers. It's quick & easy.

Conditional Formatting w/Multiple text boxes

(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!
Nov 12 '05 #1
  • viewed: 8199
Share:
2 Replies
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!

Nov 12 '05 #2

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!
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Bradley | last post: by
4 posts views Thread by mugen | last post: by
1 post views Thread by Earl Anderson | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.