AccMas and Access Terms

AccMas and Access Terms - Input Mask Property You can use...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Input Mask Property You can use the InputMask property to make data entry easier and to control the values users can enter in a text box control. For example, you could create an input mask for a Phone Number field that shows you exactly how to enter a new number: (___) _______. It is often easier to use the Input Mask Wizard to set the property for you. Character Description 0 Digit (0 to 9, entry required, plus [+] and minus [o] signs not allowed). 9 Digit or space (entry not required, plus and minus signs not allowed). # Digit or space (entry not required; spaces are displayed as blanks while in Edit mode, but blanks are removed when data is saved; plus and minus signs allowed). L Letter (A to Z, entry required). ? Letter (A to Z, entry optional). A Letter or digit (entry required). a Letter or digit (entry optional). Any character or a space (entry required). C Any character or a space (entry optional). . , : ; / Decimal placeholder and thousand, date, and time separators. (The actual character used depends on the settings in the Regional Settings Properties dialog box in Windows Control Panel). < Causes all characters to be converted to lowercase.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/05/2011 for the course SOM 492 taught by Professor Minecar during the Spring '11 term at George Mason.

Page1 / 2

AccMas and Access Terms - Input Mask Property You can use...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online