Conditional Formatting not working

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

Guest

Using Access 2003
Have a text box on a form that has "Active" or "Inactive" selected from a
table/query.
I would like the background to be black w/ pink font for "Inactive";
however, when I use Field value is equal to "Inactive" and select the
corresponding background & font colors, nothings happens to the display of
existing records. Am I entering the criteria incorrectly? Is there a bug
with my program? Your help is greatly appreciated!
 
If this is a combo box, and it is *displaying* "Active" or "Inactive",
perhaps it is Bound to a column other than this one. Usually this is the
primary key. Check the Bound Column property, and enter the corresponding
value from that column as your Conditional Formatting criteria.

Hope that helps.
Sprinks
 
Back
Top