View Full Version : Shading records that meet criteria


bunker
03-14-2002, 07:58 AM
How do I shade records on a form that meet a given criteria in a continuous record form?

Graham T
03-14-2002, 08:16 AM
You can use Conditional Formatting in the form to give certain fields differing formats dependant on a value or expression.

Take a look at this to see if this is what you are after.

I think this option may only be available in Access 2K though.

HTH

bunker
03-14-2002, 08:20 AM
I have a2k, but I am not sure what is being suggested. Can the detail record background be change while the form is opening?

expublish
03-14-2002, 08:21 AM
When in the form design view go to Format > Conditional Formatting ... It is all pretty self explanatory from there.