Conditional Formatting Code ?

  • Thread starter Thread starter Gulf Coast Electric
  • Start date Start date
G

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
 
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
 
I tried this for one form and it worked but did not for another form using
the same drop down list ???
Any Suggestions ?
 
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
 
Back
Top