backcolor on one record's field in continuous form

W

worksfire1

I have the code in my after update events for the fields I want to be yellow
when empty. What I don't know how to do is make the code only color it for
the specific record on the continuous form that is empty. Right now, it
colors all records' fields on the continous form if any one of the record's
field is empty. I am sure it is because to it, the field txtStatus is empty
in one place so it performs the action everywhere it sees that field. How
can I get around that?
 
L

Linq Adams via AccessMonster.com

Good for you! Forum ettiquette requires posting your solution so that others
searching here for a similar problem can benefit from it, as you did!
 
W

worksfire1

Found my solution here on the board! You should use conditional formatting
if you want different records in the same continous form to display different
colors depending on meeting a true false condition. I love this board. It
is so helpful.
 
Top