Conditional formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I use conditional formatting to change the fill color whenever the
field on a form has any data in it. What I mean is the fill color is grey
when there is no data in the field, I already used conditional formatting to
change the fill color to a darker shade of grey when the field has focus,
what I also want to do is change the fill color to yellow after data has been
entered. The three choices are field value is, field has focus, and
Expression is. The field values are mostly different so I cannot use Field
value is and specify a certain criteria every time.
 
Would a "Field value is" set to Not Null mean something was in the field?

Regards

Jeff Boyce
<Office/Access MVP>
 
That did not work, thanks for the help. I did find that i can use geater than
or equal to 1 for fields that contain numbers and greater than or equal to
"A" for thos fields with letters worked.
 
Back
Top