Long Integer in MS Access Error

[inso]

Hello,

I am having a problem and i couldn't find anywhere any suggestions (maybe is too simple?):blush:

I have a field in a Microsoft Access table that stores telephone numbers. Type Long Integer.When I insert a number larger than 9 digits an error occurs that i entered either an alphabetic value (which i didn't) or a number larger than the fieldsize.

What length can a long integer type store? Can i change it to store up to 14 digits?

Thanks!!!

inso

[hspc]

the maximum number that can be stored is : 2147483647

generally .. phone numbers are stored as text fields not numeric fields.

if you still insist to store it as a number.. use Decimal not long
and specify a big Precision (maximum is 28)