0 - User must enter a digit (0 to 9), 9 - User can enter a digit (0 to 9), # - User can enter a digit, space, plus or minus sign. If skipped, Access enters a blank space, L - User must enter a letter, ? - User can enter a letter, A - User must enter a letter or a digit, a - User can enter a letter or a digit, & - User must enter either a character or a space, C - User can enter characters or spaces, . , : : - / - Decimal and thousands placeholders, date and time separators. The character you select depends on your Microsoft Windows regional settings, > - Converts all characters that follow to uppercase, < - Converts all characters that follow to lowercase, ! - Causes the input mask to fill from left to right instead of from right to left, \ - Characters immediately following will be displayed literally, "" - Characters enclosed in these marks will be displayed literally,

MS Access input masks

Print
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?