- MICROSOFT ACCESS 2013 TUTORIAL 5 CASES CODE
- MICROSOFT ACCESS 2013 TUTORIAL 5 CASES PLUS
- MICROSOFT ACCESS 2013 TUTORIAL 5 CASES WINDOWS
Don’t use an input mask if following circumstances apply to you:
MICROSOFT ACCESS 2013 TUTORIAL 5 CASES WINDOWS
The character you select depends on your Microsoft Windows regional settings.Ĭoverts all characters that follow to uppercase.Ĭonverts all characters that follow to lowercase.Ĭauses the input mask to fill from left to right instead of from right to left.Ĭharacters immediately following will be displayed literally.Ĭharacters enclosed in double quotation marks will be displayed literally.Īs useful as they are, input masks are not appropriate in every situation. User must enter either a character or a space.ĭecimal and thousands placeholders, date and time separators.
MICROSOFT ACCESS 2013 TUTORIAL 5 CASES PLUS
User can enter a digit, space, plus or minus sign. The following table lists the placeholder and literal characters for an input mask and explains how it controls data entry: The third part of the input mask specifies that a hyphen ( -) instead of the underscore ( _) is to be used as the placeholder character. The 0 in the second part of the input mask indicates that the mask characters will be stored along with the data. The 9 indicates an optional digit (which makes it optional to enter an area code), and each 0 indicates a mandatory digit. The mask uses two placeholder characters, 9 and 0. If you want to use another character, enter it in the third part of your mask.įor example, this is an input mask for a telephone numbers in the U.S. By default, Access uses the underscore (_). The third part of the input mask is also optional and indicates a single character or space that is used as a placeholder. Setting the second part to 1 can save database storage space. If the second part is set to 0, the characters are stored with the data, and if it is set to 1, the characters are only displayed and not stored. The second part is optional and refers to the embedded mask characters and how they are stored within the field. It includes the mask characters or string (series of characters) along with placeholders and literal data such as, parentheses, periods, and hyphens. Input masks are made up one mandatory part and two optional parts, and each part is separated by a semicolon.
MICROSOFT ACCESS 2013 TUTORIAL 5 CASES CODE
If someone enters a phone number without the area code, Access won’t write the data until the area code data is added. For example, you might use an input mask with a field that stores phone numbers so that Access requires ten digits of input. You use an input mask when it’s important that the format of the input values is consistent. The input mask is stored as an object property. You can use input masks in table fields, query fields, and controls on forms and reports. When to avoid using input masks in AccessĪdd an input mask to a table field using the Input Mask WizardĪn input mask is a string of characters that indicates the format of valid input values. Access web apps and web databases do not support input masks. Important: This article only applies to Access desktop databases.