backcolor on one record's field in continuous form

[Guest]

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?

 

[Guest]

Finally figured it out using posts on this forum

 

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

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com

 

[Guest]

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.