change Text color in forms

D

dimpie

I have a subform in continous form type.
I want to change the color of a field in the subform only if > 30(just an
example)

How can i do this?

Please help.

Thanks
 
F

fredg

I have a subform in continous form type.
I want to change the color of a field in the subform only if > 30(just an
example)

How can i do this?

Please help.

Thanks
Click to expand...

In Form design view, select the control.
Click on Format + Conditional Formatting
Set Condition1 to
Value Is greater than 30
Select the color.
Click OK
 
Top