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.
 
Dn,

Yes. Use the 'Expression is...' option in the Conditional Formatting.
 
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.
 
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

changing textbox color 3
change background color of textfield 1
List Boxes - Access 2003 0
Chaging the color of a cell acording to its value 2
How to type each letter of the alphabet automatically in a specific color in Word? 0
Excel VBA - counting cells by colors and names to it in two different rows. 0
Changing color of a textbox in a subform 8
changing the color of a cell acording to its value 4

Back
Top