Home > Administrative Offices > Information Technology > Helpdesk > Step by Step Tutorials > Microsoft Office 2007 Tutorials > Setting up an Input Mask

Setting up an Input Mask

Step 1:

Right-click on a table and click Design View in the pop-up menu that appears.

Open Design View

 

Step 2:

Select the field you wish to apply the input mask to.

Select the Field for the Mask

 

Step 3:

In the Field Properties window at the bottom of the Design View, click Input Mask. A ... button (a button with three dots) should appear. Click this button.

Click the ... Button

 

Step 4:

The Input Mask Wizard will appear. Select the input mask you wish to apply. To verify that you have the correct input mask, click on the Try it: blank below. Then, type a sample entry into the blank. Finally, click the Next > button.

Select the Input Mask

 

Step 5:

On the next screen, click the Next > button.

Click Next

 

Step 6:

On the next screen, likewise click the Next > button.

Click Next Again

 

Step 7:

On the last screen of the wizard, click the Finish button.

Click Finish

 

Step 8:

Once you have added all the fields you wish, click the X button. Make sure you are clicking the lower button. Otherwise, you will exit Access altogether.

Close the Table, but not Access

 

Step 9:

When you are prompted to save the changes, click the Yes button.

Save Your Changes

 

Congratulations!

You have successfully set up an input mask!

If you have problems when trying these instructions, or if you have other questions, please contact the Information Technology Helpdesk at 229-245-4357 or send an e-mail to helpdesk@valdosta.edu.