Change Back Color

P

Paul Ilacqua

In Access 2002 I have a continuous forms form and I want to change a flag
field's back color based on criteria in the current record. I do it in
reports all the time but am at a loss of how to do it in a form.
Thanks
Paul
 
A

Allen Browne

If you do this in the events of the form, Access will apply the change to
all rows.

The only workable approach is to use Conditional Formatting (on the Format
menu, in form design.) This limits you to 3 possible colors (it supports
only 3 conditions), but if that is adequate then this would be a more
efficient (faster executing) approach to use in reports as well.
 
P

Paul Ilacqua

Allen,
Thank you very much.......
Paul
Allen Browne said:
If you do this in the events of the form, Access will apply the change to
all rows.

The only workable approach is to use Conditional Formatting (on the Format
menu, in form design.) This limits you to 3 possible colors (it supports
only 3 conditions), but if that is adequate then this would be a more
efficient (faster executing) approach to use in reports as well.
Click to expand...
 
Top