create an input Mask

      Create an Input Mask

you can use the Input Mask Wizard to create an input mask. An input mask is a set of simple rules that specifies the format in which data can be entered into a field.

For example :- an input mask of (999) 000-0000 could be used to determine how phone numbers are entered. In this example, the area code is optional, but the rest of the number is must be entered. This is because, with any input mask, a 9 specifies an optional number, a 0 specifies a mandatory number.

Using the Input Mask Wizard

We're now going to apply an input mask to the ReleaseDate field of our Albums table. Our input mask will ensure that users enter each album's realease date in the correct format.

Screenshot of Design View icon on the Ribbon.

Open the Albums table and Launch the Input Mask Wizard

Open the Albums table in Design View.

Click on the ReleaseDate field then look to the bottom frame. The bottom frame displays the properties for this field.

In the bottom frame, click somewhere in the Input Mask row. A small button with three dots will appear. This button launches the Input Mask Wizard.

Click that little [...] button with the three dots

Screenshot of Design View

Select an Input Mask

The Input Wizard Mask presents you with some options for how you'd like the data to be entered. You can select any option and test it in the Try It field at the bottom of the wizard.

Select Medium Date and click Next >.

Screenshot of the Input Mask Wizard

Customize the Input Mask

This screen allows you to make adjustments to the input mask. You can test any adjustments in the Try It field at the bottom of the wizard.

We'll make one minor adjustment.

Add two zeros, so that the input mask becomes: 99->L<LL-0000

This will ensure the user enters the date as DD-MMM-YYYY. For example, 20-Mar-2016.

Once you're happy with the input mask, click Next >.

Screenshot of the next stage of the Input Mask Wizard

Close the Input Mask Wizard

The Input Mask Wizard will show you one last screen (and give you one last chance to go back to change your input mask).

Click Finish instead.

Screenshot of the dialog to close the Input Mask Wizard

Your newly created Input Mask

Once the Input Mask Wizard closes, you'll see your newly created input mask against the Input Mask property in Design View.

Our Input Mask Explained

We just created an input mask that looks like this: 99->L<LL-0000

This specifies how the date should be entered. Here's an break down of each part:

  • The 99 part defines two optional numbers (i.e. for the day). So the user has a choice of entering that part of the date. But if they do, it must be a number.
  • The >L specifies that the user must enter an uppercase letter for that part of the date.
  • The <LL specifies two lowercase letters for that part of the date.
  • The 0000 specifies four numbers for that part of the date.

Comments

Post a Comment

Popular posts from this blog

vocab

Image
       Meaning vocabulary is a term that describes how people learn the meaning of words. Children can learn the meanings of words by using context clues, word part instruction and graphic organizers. Meaning vocabulary entails words for which their meanings are understood and it is an important component of comprehension. Direct instruction in meaning vocabulary is essential. If vocabulary is not developed, children will be unprepared to handle vocabulary demands of content-area subjects. Its significance is also displayed in comprehension and interaction with others. Meaning vocabulary helps to build social skills, confidence and self-esteem in children. It also enables children to use context clues to decipher word meaning. It helps children to construct more interesting stories and to communicate effectively with their peers and just about anyone with whom they interact. The more words they know, the more aptly they will be able to communi...
Read more

📚Gds-Tech 📚 EMS

Image
In this competitive world, 'Vocabulary' plays a vital role in every exam. Several banking and Government exams are round the corner like IBPS PO, Clerk, IBPS RRB, SSC-MTS, CGL, CHSL, State Level exams , Other Exams etc.  Gds-Tech Educational sollution  provide you 10 new words in  Gds-vocab  on the daily basis which will benefit you in upcoming examinations.  The Gds-Vocab  includes the word with the meaning, synonyms, antonyms along with the example given in  " The Gds Info-Skill Times "   pages. As we all Know in English section the vocabulary comes from THE HINDU Newspapers in the most bank and competitive exams and it is very essential to read and memories vocab from The Gds  Vocab daily. You can test your vocabulary and evaluate yourself with regard to your respective exams. You can easily learn The words form Gds  Vocab   regular basis .          Gds ...
Read more

spreadsheet in excel

Image
What is a Spreadsheet A spreadsheet is a file that exists of cells in rows and columns and can help arrange, calculate and sort data. Data in a spreadsheet can be numeric values, as well as text,  formulas ,  references  and  functions . Rows, columns and cells in a spreadsheet The rows in a spreadsheet have numeric names (1, 2, 3 etc) and the columns have alphabetic names (a, b, c etc), thus the names of cells subsequently exist of a letter and a number that conveniently point out their position in the grid Selection of a row In the image above row 3 is selected. This can be done by clicking on the number 3 in front of the row. Selection of a column In the image above column B is selected. This can be done by clicking on the letter B above the column. Selection of a cell In the image above cell B3 is selected. This can be done by clicking on the cell. Worksheets A spreadsheet can contain one or several worksheets (tabs). Adding worksheets can be done by clicking the...
Read more