color change

[JIM.H.]

Hello,
I am using this following Focus event to change the color
in a tabular form for filed f3. The problem: this
changes f3 field in all rows, I just want to changed the
color on the current filed.

Private Sub f3_GotFocus()
lngRed = RGB(255, 0, 0)
lngBlack = RGB(0, 0, 0)
lngYellow = RGB(255, 255, 0)
lngWhite = RGB(255, 255, 255)

Forms!form1!f3.BackColor = lngYellow
Forms!form1!f3.ForeColor = lngRed

End Sub

How can I do that?
Thanks,
Jim.

 

[Steve Schapel]

Jim,

You can use Conditional Formatting to change the colour of the control
for an individual record when the control itself has focus. Otherwise,
have a look at Stephen Lebans code at
http://www.lebans.com/formatbycriteria.htm or
http://www.lebans.com/conditionalformatting.htm