change color of text to red if "state field" = MA 1

[gorillawarfare]

how could i change the color of the text field on my form if the state = MA????

 

[PHV]

Conditional formatting ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[TheAceMan1]

How are ya gorillawarfare . . .

[ol][li]In form design view select the [blue]state[/blue] field.[/li]
[li]From the menubar select [blue]Format - Conditional Formatting.[/li]
[li]In the conditional formatting dialog select [blue]equal to[/blue] from the combobox.[/li]
[li]In the textbox to thr right of the combobox enter [blue]"MA"[/li]
[li]Select the [blue]font color[/blue] then click [blue]OK[/blue].[/li][/ol]
Thats it perform your testing ...

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[gorillawarfare]

thanks TheAceMan1 worked fine hey listen to bring this thin a little further how would i make the backcolor red also

 

[TheAceMan1]

gorillawarfare . . .

In the [blue]conditional formatting[/blue] dialog you can change both foreground & background colors. Also note that you can set 3 conditional formats ...

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]