By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,986 Members | 1,522 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,986 IT Pros & Developers. It's quick & easy.

Which Datatype to use for Phoneno

100+
P: 274
hi all
Which datatype I should use in Access to store phone numbers that will be of max this long
7785999999
I am using text I think its bad approach.
Nov 24 '07 #1
Share this Question
Share on Google+
3 Replies


QVeen72
Expert 100+
P: 1,445
Hi,

Text is the Best approach.
As I feel, in future, if you need to add STD/ISD Codes to phone Number,
(say +(91)-080-202922828), Text's are easy. You cannot store such data in Numeric Fields.
Just From Front End Validate the Textbox accordingly..

Regards
Veena
Nov 24 '07 #2

Mohan Krishna
100+
P: 115
Hi !

As Veena said it is suggestible to take TEXT for such numerical values, which don't need any calculations to operate on.

ALL THE BEST!
Nov 25 '07 #3

Expert 5K+
P: 8,434
Text is the Best approach.
As I feel, in future, if you need to add STD/ISD Codes to phone Number,
(say +(91)-080-202922828), Text's are easy. You cannot store such data in Numeric Fields.
Actually, you can. But you may not want to. You would have to do it carefully, and format for display when you retrieve it.

For instance, you could store this as a 14-digit number and just add the other characters on the display. It seems like more work, but depending on the circumstances it may be useful to make the data smaller or help with things like grouping the data.
Nov 26 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.