Input Mask property in MS Access

The Input Mask property is used to change the format of a field having the Text or Date/Time datatype. This property provides the formats for different types of data such as zip-code, phone, date, time, password etc. The InputMask property can be used to make data entry easier and to control the values users can enter in a text box control. When the Input Mask property is set for a field, a user should fill the data in the same format. Any other format is either converted to the given format or remains as it is.

Input masks are helpful for data-entry operations such as 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.

Share

About Sam

I am an MCAS: Windows Vista, MCTS: Business Desktop Deployment, MCTS: Microsoft Office Project 2007. This blog is all about MCAS. I will be sharing information about MCAS exam. I am here to share information about different Microsoft exams. You all can ask questions from me about any certification exam and you can also share your experiences with me.
Posted in 77-605. Tags: , , , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>