Place the following function call in both the ON GOT FOCUS and ON MOUSE MOVE events of the buttons or text boxes that you want to highlight. The ON MOUSE MOVE event responds to moving the mouse over the control and ON GOT FOCUS handles using the keyboard to navigate.
=MouseOver("OptionLabel1","Option1"
Place these two functions in the CLASS MODULE of the form that contains the controls.
Sub ChangeMe()
Dim frmControl As Control, i As Integer, sName As String
For Each frmControl In Me.Controls
For i = 1 To conNumButtons
sName = "OptionLabel" & LTrim(str(i))
If frmControl.Name = sName Then
frmControl.ForeColor = 0
End If
Next
Next
End Sub
Private Function MouseOver(sLabel As String, sControl As String)
Call ChangeMe
Me(sLabel).ForeColor = 128
Me(sControl).SetFocus
End Function
Enjoy,
Dan