Conditional Formatting in ACCESS??

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

On Mon, 7 Jun 2004 17:01:08 -0400, "Mike G" wrote:

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


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.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public