Access 97 Field Colors

This should be an easy one….

On an Access 97 Form I have 3 fields. (AssocQ AssocF & AssocR).

If any of these fields have NO ENTRY, I want the color of the field box to be RED. If an entry is made, NO color change should occur.

I used the On Change event and wrote some code for each field, BUT my code changes the color of the box for EVERY RECORD in the table. I want only THOSE records where the field is empty to be colored.

Thanks in advance for your help…..

A2
MRA@mindspring.com