Which Datatype to use for Phoneno

[creative1]

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.

[QVeen72]

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

[Mohan Krishna]

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!

[Killer42]

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.