Changing textbox color acording to data

  • Thread starter Thread starter Guest
  • Start date Start date
Dn,

Select the textbox in design view of the form, select 'Conditional
Formatting' from the Format menu, and set up as required.
 
thanks,..
but can I change the appearence of one textbox according to value change of
another textbox.
 
Steve

Conditional formatting only allows for 3 conditions. What if i have 6
conditions. Can I do that in code and how in a continuous form.
 
Eric,

You can use a user-defined function to allow the evaluation of more than
three conditions, but you are still limited to three colours. I have
seen a suggestion from Marshall Barton of a way to get more colour
options by using textboxes layered over each other. I have never tried
it. If you're interested, you could try a Google search, or else I can
fish out the information for you.
 
Back
Top