Access Table Field with Input Mask - Initial Cursor position

Question

I have a field that must be 4 numbers - leading zeros must be entered (ie. 0123, not 123)

In design view I specified an input mask:   0000:1,#

The issue is that the cursor is initially positioned at the end of the field, after the 4th #.

This requires the user to reposition the cursor to the beginning of the field - quite a nuisance.

Am I doing something incorrectly or is this a design issue?

Thank you

Running Windows 10, Office 365 Home with all updates applied - Version 1901 (Build 11231.20174)

Answer 1

In Design View, click on the Control and look on the Event tab on the Property Sheet.  Of course, this only applies if you are using a Form in Datasheet View.

Answer 2

A form has a datasheet view.

Answer 3

Thank you for your reply. 

I was trying to accomplish this in the datasheet view as well as in a form. 

In the design view I do not see the event list for a field in the field properties list.

Answer 4

You could put...

Me.YourControlName.SelStart = 0

...in the On_GotFocus event of the Control.  This will put the cursor at the beginning of the Control.

EDIT:  I should have mentioned this is normal behavior that can be changed under Options but it does change it everywhere.  The above is on a Control-by-Control basis.

Answer 5

Just noticed a typo.  The Input Mask is 0000;1;#