Change Color In a Text Box

[Vance]

I have a text box that I would like the background color to change if the
value of the text box is greater than XXXXX, where XXXXX is an integer.

Thanks in advance

 

[Al Campagna]

Vance,
If you're using Access 2000 or greater, check out Conditional Formatting
in Access Help.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[MikeJohnB]

With the form in design view, select the text box, select formating,
Conditional Formating, in the first option set to "Field Value is", Next
Cell, "Greater Than" enter your "integer" in the right hand box. Set the back
colour to the colour you want.

Without Quotes

 

[Mrs. Ugh]

Assuming you are in a form, in design view click on the text box and select
Format/Conditional Formatting. Enter the info in the pop-up window. If you
need to do a calculation first, or want the color of a different field to
change, use an If statement in the After Update event of the driving field.
Jill

 

[Vance]

Worked perfectly. Thank You for the help.

With the form in design view, select the text box, select formating,
Conditional Formating, in the first option set to "Field Value is", Next
Cell, "Greater Than" enter your "integer" in the right hand box. Set the back
colour to the colour you want.

Without Quotes
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B