In MS Access form, how to color background of selected record?

Question

I have a somewhat complicated looking Access Form with a continuous display (meaning multiple records are shown at once). I'd like to change the background color of the selected record only so the end-user can easily tell which record they are on.

I'm thinking of perhaps a conditional format or maybe something like this:

Private Sub Detail_HasFocus()
    Detail.BackColor(me.color)=vbBlue
End Sub

and something similar for when that row loses focus. This code snippet obviously won't work, but it's the kind of code I'd like to achieve.

Answer 1

Here is a sample from MVP Dev Ashish on coloring in continuous forms.

http://www.mvps.org/access/forms/frm0024.htm