Hi Aceman! How are ya? Tried this and it works, but shows every [!]instance[/!] of that control. The problem is that the control in question resides on a continuous subform, so if I conditionally format it based on having the focus, it formats the entire column worth of that control.
The way I did this was to put the name of my control in an unbound text box on enter or get focus. Then, using conditional formatting I refer to the control containing the name, like this:
My unbound control is called txtActiveControl. In the Enter and GotFocus events, for example, of my text box called PaidHours, I put the following line of code:
Code:
Me.txtActiveControl.Value = "PaidHours"
Then I used the following expression in the conditional format for PaidHours:
Code:
=[txtActiveControl].[Value]="PaidHours"
Works great for highlighting the control, but I have a whole column of instances of PaidHours since I'm viewing my form as a continuous form. The trouble is my user gets interrupted frequently during data entry and is frustrated with looking around to find her insertion point.
Maybe working with the active record might do the trick, but I'm not sure how to refer to a control in the active record. Then again, maybe not since the active record deals with a data set, not a form object, unless of course I'm confused again (which wouldn't surprise me
![[evil] [evil] [evil]](/data/assets/smilies/evil.gif)
).
Tom
Live once die twice; live twice die once.