Field Highlighting

[csegal]

I am using Access 97,
Is it possible to highlight a field as I toggle through the form. For instance, the current field background color is WHITE. When I select a field I would like it to be light BLUE or YELLOW etc... then when toggled to the next field the previous fiels goes back to WHITE and the next field becomes highlighted to whatever color.

Thanks
csegal@arrowair.com

 

[lennyl]

Use the gotfocus and lostfocus events to change the backcolor property

 

[Garridon]

This will do what you're looking for. It turns the field yellow:

Insert the following code into the OnGotFocus event procedure for a field:

Private Sub txtAssignedTo_GotFocus()

Highlight ("GotFocus&quot

End Sub

Insert the following code into the OnLostFocus event procedure of the field:

Private Sub txtAssignedTo_LostFocus()

Highlight ("LostFocus&quot

End Sub


Insert the following code into a module:

Function Highlight(Stat As String) As Integer

Dim ctrl As Control

On Error Resume Next

Set ctrl = Screen.ActiveControl

If Stat = "GotFocus" Then
ctrl.BackColor = 65535

ElseIf Stat = "LostFocus" Then
ctrl.BackColor = 16777215

End If
End Function
Linda Adams
Linda Adams/Emory Hackman Official Web site

http://www.hackman-adams.com

Official web site for actor David Hedison:

http://www.david-hedison.com