Solved

Formatting a number field to accept phone numbers

Posted on 1998-12-30
2
533 Views
Last Modified: 2008-02-26
I currently have a phone number field with this input mask --   000\-000\-0000

When I try using this field to enter data I get an error message saying that I've entered too many numbers for this field's format.  I've tried all the available formats and even tried customizing my own, obviously to no success.  Someone please get me out of this mess!!  
0
Comment
Question by:Phreke2n
2 Comments
 
LVL 1

Accepted Solution

by:
ssteeves earned 50 total points
ID: 1972333
Try this.  (I'm using Access 97, so I don't know if we're in the same version).
Open your table in Design mode.  Click on the Phone number field.
In the Input Mask type the following:

!\(999") "000\-0000;;_

Save your table, and see if you don't have better luck.
0
 
LVL 10

Expert Comment

by:brewdog
ID: 1972334
You won't be able to do what you're trying to do if this is a number field. Phone numbers, zip codes with plus 4, etc., all have to be text fields because of the dashes, slashes, and parentheses. Your input mask will work fine if you change your data type.

brewdog
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question