Access JumpStart 2.0 | Blog

A Rapid Development Framework for Microsoft Access

So I was wrong yesterday about phone number input masks and input values.

An input mask value specifies a format, whether the mask is stored in the value, and the placeholder for users to enter data into the mask.

This Microsoft web site discusses the pros and cons of using masks and more info about mask characters: https://support.microsoft.com/en-us/office/control-data-entry-formats-with-input-masks-e125997a-7791-49e5-8672-4a47832de8da

Anyhow, I was just wrong and happened to be using the default options when creating my mask.

The value that will store the mask uses a 0 after the mask definition like this:

!\(999") "000\-0000;0;_

Whereas a 1 for that option will store only the user entered data, and that looks like this:

!\(999") "000\-0000;1;_

The exclamation point at the beginning makes sure the characters are entered from left to right, and the backslash is in front of otherwise special characters that would mean something else, but the backslash means use them as a character in the mask.

Sign up For a Daily Email Adventure in Microsoft Access

Every business day (typically M-F), I'll send you an email with information about my ongoing journey as an advanced Access application developer. It will be loaded with my tips and musings.

    We won't send you spam. Unsubscribe at any time.