Change color of text box on Form

R

Rubie

Hello,

I have a text box on a form that is setup to show percentage. How do I get
the text box to turn (Red if the percentage is 79 and below) and turn (Green
if the percentage is 80 and above)?

Any help on this would be greatly appreciated.
 
K

Kenny G

Place the form in design mode. Select the field you want. Right click and
select "conditional formatting".

On Condition 1 utilize if Field value is > value then select colour.

On Condition 2 utilize if Field Falue is < value then select colour.

Cheers
 
R

Rubie

It worked!! Thanks a bunch Kenny.

Kenny G said:
Place the form in design mode. Select the field you want. Right click and
select "conditional formatting".

On Condition 1 utilize if Field value is > value then select colour.

On Condition 2 utilize if Field Falue is < value then select colour.

Cheers
Click to expand...
 
Top