Access: Now Playing (Page 1) 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44

 

Table Tools -> Design -> View->-> Design View

Zip Code Mask

Try it: Create the Zip Code Mask

Select the Zip Code field

Select the Input Mask field property

Click on the three-dot Code builder

 

Select the Zip Code Mask.

Review the Input Mask code

Finish the Wizard

 

The completed Input Mask is pictured on the right. Save the table and close it.

 

  Microsoft Access 2007 Exam 77-605 Topic: 2.  Creating and Formatting Database Elements

  2.4.2.   Modify field properties: Define input masks for fields