Conditional formatting.

[CTS]

I created a data access page that was meant to show troubleshooting ideas and
solutions. I would like to apply conditional formatting to one of the
textboxes on the page. I would like for the background in one textbox to turn
red if there is no text in another textbox. I know this is probably going to
call for a script, yet i am absolutely new to scripting. If this is not
possible. or too much for a novice I would understand. Any help is always
appreciated

 

[boblarson]

Have you tried using Conditional Formatting? You go into the text box (in
design view) that you are going to want formatted and then go to FORMAT >
CONDITIONAL FORMATTING and change the selection from "FIELD VALUE IS" to
"EXPRESSION IS" and put in the expression as Nz([YourOtherFieldNameHere]," ")
= " " and then select what color you want if the text box meets that
condition.
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
If my post was helpful to you, please rate the post.
__________________________________