Setting input masks


show more Setting input masks provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training show less
please wait ...

Setting input masks

Input masks are a field property that automatically formats phone numbers, Social Security numbers and other data so that all you have to do is enter the numbers themselves. Let's go to our Sales Rep Table and open it in Design View. Click on the HomePhone and then on the Input Mask line down here, click on the Build button on the right-hand side. Now Phone Number is already highlighted. Click down here to Try It. You'll notice though that you have to click in the very beginning of the box.

Otherwise, your cursor will land somewhere within the middle of the Input Mask. Try typing just the ten digits of the Phone Number. Click Next. If you want to change the underscore to a different character, do so here. We'll leave it as an underscore. Click Next. Now click the top option, so that the symbols get saved with the Mask. Otherwise, when you include the Phone Number in Reports, you won't see the parentheses, spaces and punctuation.

Click Finish. Now repeat the same steps for C...

Setting input masks
Video duration: 2m 3s 3h 30m Beginner

Viewers:

Setting input masks provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training

please wait ...