Cursor to Left of Field on Click

[irunergoiam]

I have a field for recording social secrity number with an input mask. I'm finding that end users are clicking into the field (instead of tabbing from field to field) and getting confused when it comes to going to the far left of the field to enter the data.

How do I create an On Click or On Enter event that will move the cursor to the far left of the field to simplify data entry for the end user?

Thanks much for any help those of you with superior Access knowledge might offer.

 

[georgedwilkinson]

In the "On Click" (or whichever you want to behave this way) event of the control, put some code similar to this:

ActiveControl.SelStart = 0

In place of "ActiveControl" you could put the name of the control. You can get to the "On Click" event of a control by right clicking the control in design mode, select "Properties", click "Event", click on the ellipses to the right of "On Click", select "Code Builder", click "Ok".

 

[irunergoiam]

I guess I'm unfamiliar with the kind of control that I would use. Probably a simple question, but what would I use in place of "Active Control" if I just want the cursor to move to the far left of the field On Click?

 

[rainman89]

You would put the name of your social security field name in there.

 

[irunergoiam]

Thank you GeorgeDWilkinson for getting me started and thanks to you Rainman89 for the gentle nudge on the field name. Works like a charm!!