Conditional Formatting in ACCESS??

  • Thread starter Thread starter Mike G
  • Start date Start date
M

Mike G

I have a data base that lists clients names etc. I have one field in each
record that makes these clients Active=A or Inactive=I. I would like to
change the entire record background to yellow if =I. Is this possible.
Tx Mike
 
I have a data base that lists clients names etc. I have one field in each
record that makes these clients Active=A or Inactive=I. I would like to
change the entire record background to yellow if =I. Is this possible.
Tx Mike
Click to expand...

What version of Access? Conditional Formatting came in with A2000 (or
maybe 2002, don't remember for sure).

Select the textboxes or the background of the form and select
Format... Conditional Formatting from the menu. Use a condition
[Fieldname] = "I" and set the color as desired.
 
Back
Top