What is the best way to enter a phone number into a data table? 1112222 (111)222-3333 111-2222 111-222-3333 1112223333?
Reply from Alex Hedley:
Hi Bobby, Although a phone number is made up of numbers it's best to use a TEXT Field to store it. Number fields are used for Calculations. You're not going to add up a list of phone numbers. You set an Input Mask on it it just straight numbers. You can then set a FORMAT on the number to show brackets () or hyphens -
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 1.
