how do you change textbox color control depending on value

C

chuck

I am trying to change the color of a text box if the value falls below a
certain number. How do I do that or what is the expreesion that I can use in
a form field to do that.
 
A

Allen Browne

Use Conditional Formatting (on the Format menu in form design.)

Set Condition1 to an expression such as this:
[Quantity] < [MinQuantity]
 
Top