microsoft access 2013 tutorial 5 case problem 2

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. 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.

Microsoft access 2013 tutorial 5 case problem 2