What is input mask? #
Input masks are guides to help users enter data in the correct format. The idea behind the input mask is to keep the data entry process somewhat uniform and minimize the chances for incorrect data to be entered into the field. You use an input mask when it’s important that the format of the input values is consistent.
For example, you might use an input mask with a field that stores phone numbers so that Access requires ten digits of input. If someone enters digit more or less than ten digits, Access won’t write the data until ten digits is added.
Custom Input Mask Rules
- 9:Numeric (0-9)
- a:Alphabetical (a-z or A-Z)
- A:Uppercase alphabetical (A-Z)
- *:Alphanumeric (0-9, a-z, or A-Z)
- &:Uppercase alphanumeric (0-9 or A-Z)
How to Add Custom Input Mask
- You must create new form or edit an existing form to add custom input mask.
- Input masks can only be added to Single Line Text field.
- Drag and Drop Single Line Text.
- After dragging Single Line Text click on click on the form field on the right side to open up the Field Options.
- In Field option go to Advance Option. In advance field option you can see Input Mask option.
You can now mask input from here.
For example, if you’d like to require a 10-digit number you could enter ten 9‘s into the Input Mask field.
When the form is displayed on a page and a user clicks in the field, an underscore will be shown for each required digit to help guide the user. Additionally, since we used the 9 symbol, only numeric values will be allowed (no letters or other symbols). You can add alpha numeric value to mask input as mention above.
Additionally you can include symbols like hyphens (-) or parenthesis in your input mask.
