how do you change textbox color control depending on value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Use Conditional Formatting (on the Format menu in form design.)

Set Condition1 to an expression such as this:
[Quantity] < [MinQuantity]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change the font color/background of a text box depending on value 6
color coding values 1
Change textbox color based on matching value in different textbox 4
Changing color of a textbox in a subform 8
edit a bound textbox control on a form 3
Windows 7 Default page color for e-mail (Outlook) 1
Change Textbox Color based on ID 1
Color changing VB Code 0

Back
Top