Link to home
Start Free TrialLog in
Avatar of tpigielski
tpigielski

asked on

Setting cursor in phone number field (text box)

I have an Access 2007 form, which contains a text box represented in a phone number format, e.g.

!\(999")"000\-0000

If the field is empty, I would like the cursor to be placed at the beginning of the field.
If the field contains a phone number, I would like the cursor to remain where the user clicked the field.

How would I go about doing this?

Thanks...Tom
Avatar of PatHartman
PatHartman
Flag of United States of America image

I'm not sure you can control that.  The input mask gets in the way of normal data entry.  You can try changing the "Behavior on entering field" property in  file/options/client settings but I'm not sure that would help.  I like it to select all when the user tabs into a field.  The problem is that this setting is universal so changing it changes it for EVERY database.
ASKER CERTIFIED SOLUTION
Avatar of tpigielski
tpigielski

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of tpigielski
tpigielski

ASKER

Other answer did not solve my problem.