How can I change the background color of a single record text box of a multiple item form?

[Vision]

I have created a multiple item form for a simple table, not part of a relationship to any other table. I need help changing the color of a single record textbox control upon the mouse hovering inside the control. I would like to change the color to yellow (like PostIt Note yellow or RGB(255,255,204)). Then, when the mouse cursor is no longer focused on that particular text control for that individual record, the color returns to it's former color. My previous attempts at VBA code would change that text control for the entire field (i.e., every single text box turned yellow in that field). Here is what the multiple item form looks like:



So when my mouse hovers over the box with the "William" record in the [First Name] field, the background color of the text box containing "William" turns yellow, but nothing else turns yellow. So [Last Name], [Phone Number], etc would not change color and no other [First Name] record turns yellow either. Then, when my mouse leaves "William" and moves to "Steven", the "William" text box goes back to the original color and "Steven" becomes yellow, and so on down the [First Name] field. I feel comfortable with both Macro and VBA solutions.

The following code is very close, but produced the wrong result, highlighting every record under the [First Name] field in the multiple item form, instead of just a single text box control of a single record.

Private Sub txtFirstName_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
    If Not Me.txtFirstName.BackColor = vbYellow Then Me.txtFirstName.BackColor = vbYellow
End Sub

Private Sub Detail_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
    If Not Me.txtFirstName.BackColor = vbWhite Then Me.txtFirstName.BackColor = vbWhite 
End Sub

[NGFLNG1]

http://www.experts-exchange.com/arti...MS-Access.html See if this article helps.

[Vision]

http://www.experts-exchange.com/arti...MS-Access.html See if this article helps.

Thank you NGFLNG1 for looking into this. This was one of the first websites I came across when I did the initial Google search for a solution. Unfortunately, Experts-Exchange stops short of providing a complete answer. There is an option to "View Next page" at the bottom of the weblink you provided, but when you go there, they try to get you to pay them money to see the rest of the solution. I'm big on freedom, but low on cash.

[June7]

That is why posting links to ExpertsExchange is discouraged.

Unfortunately, what you want likely is not possible with form in continuous or datasheet view because programmatic setting of control property is reflected in all instances of that control.

Conditional Formatting is the only way to change a control's appearance between records on a form and the feature you want is not available with Conditional Formatting.

[Missinglinq]

The closest you can come to this, with a Continuous or Datasheet View Form, is actually clicking into the Textbox, and using Conditional Formatting, as June7 said> Under 'Condition' select 'Field Has Focus'.

Linq ;0)>