By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,836 Members | 1,840 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,836 IT Pros & Developers. It's quick & easy.

Conditional Formatting w/Multiple text boxes

P: n/a
(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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a

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.