Change Color In a Text Box

  • Thread starter Thread starter Vance
  • Start date Start date
V

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
 
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
 
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
 
Worked perfectly. Thank You for the help.

MikeJohnB said:
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
Click to expand...
 
Back
Top