Conditional Formatting Code ?

[Gulf Coast Electric]

I have a field on my form named Text57 which I use to store the value of
either Employee Checks or Hourly Contractor Checks,
I would like to change the color of the field to Yellow if the value chose
is Employee Checks, How do I do this?

Thanks,

Dave

 

[Rick]

Click the field. Select "Conditional Formatting" from the "Format" menu.
Enter a criteria such as..'

field value is equal to "Employee Checks"

click the text color button and select the color you desire.

Rick

 

[Gulf Coast Electric]

I tried this for one form and it worked but did not for another form using
the same drop down list ???
Any Suggestions ?

 

[Damon Heron]

You said a text field first, now a dropdown list (by that I assume you mean
a combobox). The value of the combobox is a number (like Product
ID(numeric) and ProductName(text)), so the value of the conditional
formatting would be numeric instead of text.

HTH
Damon