How To Format Phone Numbers In Access 2007


Access 2007 databases are used to analyze large volumes of data. When adding data to the database, it may be necessary to modify the fields so they are in a familiar format. For example, if your table contains telephone numbers, you can format this field by adding an input masks. Input masks add a layout to your field so the data entered is in the proper format. This is helpful for fields like telephone numbers, zip codes and social security numbers.

  • Open Access 2007 and select a database from the right "Open Recent Database" list. The database opens.

  • Right click a table in the Navigation Pane. Select "Design View." Click the field containing the phone number. Look in the lower "Field Properties" and click in the "Input Mask" field. Click the "..." icon. Select "Phone Number." Click in the "Try It" field. Notice the default input mask. Click "Next."

  • Review the input mask and click "Next." Decide if you want to store the data with the formatting or without the formatting. Make the decision by clicking the radio button. Click "Finish."

  • Click the "View" button and change the view to "Datasheet View." If prompted, click "Yes" to save the table. Click in the phone number field and notice the input mask.

Related Searches


Promoted By Zergnet



You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!