Changing field colors on a continuous form

[JR]

I have a flat database with a simple continuous form that displays one line
per record. What I would like to do is to change the background color of one
or more fields in a line/record whenever two fields in that line are not
equal, such as ...

if Me.field1 <> Me.field2 Then Me.field1.BackColor = vbYellow

I'm quite sure this would work if I were tabbing through the fields and I
used the OnCurrent event or something similar, but I would like it to do this
when the form opens. For the life of me, I can't seem to figure out how to
do this and would appreciate the help of one of you more experienced guys.

 

[JR]

Never mind. I got the info I need from another forum. It's the conditional
formatting function.