D
dn
I want to change the color of the text box according to text on it.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
Steve Schapel
Dn,
Select the textbox in design view of the form, select 'Conditional
Formatting' from the Format menu, and set up as required.
Select the textbox in design view of the form, select 'Conditional
Formatting' from the Format menu, and set up as required.
D
dn
thanks,..
but can I change the appearence of one textbox according to value change of
another textbox.
but can I change the appearence of one textbox according to value change of
another textbox.
S
Steve Schapel
Dn,
Yes. Use the 'Expression is...' option in the Conditional Formatting.
Yes. Use the 'Expression is...' option in the Conditional Formatting.
E
Eric Blitzer
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.
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.
S
Steve Schapel
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 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.