How to have the field change colour when it is selected?

[newtoAccess]

I was told that access has the ability to have a field change colour when it is selected (click or tab) to indicate what field is selected, and then when not selected changed back to the normal colour.

Does anyone know how to do this?

It may have something to do with "on got focus and on lost focus"

[RuralGuy]

I would agree and then put code that plays with the BackGroundColor in those events.

[newtoAccess]

I am new so where does the code go and what code do I use?

[RuralGuy]

How about you take your best guess as to what the code should look like and where it should go and then try it. Post your results and I will offer comments.

[newtoAccess]

How about sometning like this.. I do not know wether to use vbyel or vbyellow or a code for color or even if I have to use vb at all.


Private Sub Event_test_Main_GotFocus()
background -Color: vbyel
End Sub


Private Sub Event_test_Main_Lostfocus()
background -Color: vbWhite
End Sub

[RuralGuy]

Not bad. If the control were named txtMover then the code would be:

Private Sub txtMover_GotFocus()
   Me.txtMover.BackColor = vbYellow
End Sub
Private Sub txtMover_LostFocus()
   Me.txtMover.BackColor = vbWhite
End Sub

[newtoAccess]

It is not working perfect yet. Sometimes the lost focus does not work. The Field stays yellow and sometimes thefield does work..

-----------------------------------

Private Sub Cost_GotFocus()
Me.Cost.BackColor = vbYellow
End Sub
Private Sub Cost_LostFocus()
Me.Cost.BackColor = vbWhite
End Sub
Private Sub Date_Main_GotFocus()
Me.Date_Main.BackColor = vbYellow
End Sub
Private Sub Date_Main_LostFocus()
Me.Date_Main.BackColor = vbWhite
End Sub
Private Sub Event_02_GotFocus()
Me.Date_Main.BackColor = vbYellow
End Sub
Private Sub Event_02_LostFocus()
Me.Event_02.BackColor = vbWhite
End Sub
Private Sub Event_test_Main_GotFocus()
Me.Event_test_Main.BackColor = vbYellow
End Sub
Private Sub Event_test_Main_LostFocus()
Me.Event_test_Main.BackColor = vbWhite
End Sub
Private Sub Item_1_Time1_GotFocus()
Me.Item_1_Time1.BackColor = vbYellow
End Sub
Private Sub Item_1_Time1_LostFocus()
Me.Item_1_Time1.BackColor = vbWhite
End Sub

[RuralGuy]

In order for the LostFocus event to fire you have to put the focus somewhere else that can take the focus. Maybe the OnEnter and OnExit events would work better for you. Or maybe both events.

[newtoAccess]

OnEnter and OnExit Do I wor the same as got focus?

will they work on a field?
something like this:

Private Sub Cost_OnEnter()
Me.Cost.BackColor = vbYellow
End Sub

Private Sub Cost_OnExit()
Me.Cost.BackColor = vbWhite
End Sub

[RuralGuy]

Just for the record, tables have fields and forms have controls. Controls can be bound to fields in the RecordSource of a form. If you go to Access help and key in events, you can see all of the events of a form and the order they occur. The answer to your question is yes.