Setting color for record

[Ramzess II]

Greetings.

Is it possible in MsAccess, to make thing like this:

I have a table with number of records, each record consists of many fields and one of them is check box.

I'd like to open this table via form in way of continious form or in datasheet view, and to have records where check box is true green, and others red.

In other words, I would like to open a table which contains info on bills, and
to see which are payed and which are not payed by setting the colors of font - green for payed and red for vice versa.

Is it possible? And if that is, can anyone tell me how?

Thank you in advance.
Ramzess II

 

[___]

If you are using A2k or above you can use conditional formatting.

In design view goto Format >> Conditional Formatting

HTH