Continues Form problem

[Zeroanarchy]

Having issues with a continues form in that if I want to change the color of one of the fields as follows:

If [2] >= 1 Then
Me.[2].BackColor = RGB(255, 0, 0)
Else
Me.[2].BackColor = RGB(255, 255, 255)
End If
End Sub

What happens is that the first entry in [2] set the color for all the rest of the entries on the contiues form.

The form has a Form Header
Form Footer
Page Header
Page Footer
And Details, the details is continues..
Anyone got any answer for this one.
Thanks

 

[ToeShot]

I Believe there is something at this site for that or it has a link to one that does. I rememebr seeing it before.

http://www.wa.apana.org.au/~abrowne/

 

[gusbrunston]

Dear Zero:
Sounds like you might have your code in the wrong event--that is, you may have it in an event for the form itself rather than for a control on a record.
Gus Brunston
An old PICKer
padregus@home.com

 

[JimHorton]

zero,
Unfortunately, that is standard behaviour. Nothing aside from spaghetti-like api use will change that.
--Jim