Change Back Color

[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

 

[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.

 

[Paul Ilacqua]

Allen,
Thank you very much.......
Paul

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.