Pretty easy question, i think.

[paultri]

I am simply trying to get a field in a table to hold a 16 digit credit card number, i have tried and i keep getting the error "The value you entered isnt valid for this field" "for example, you may have entered text in a numeric field or a number that is larger than the filedsize setting permits."

I have the field set as a "number" and FieldSize set to long intger. I have tried all the other settings in the FieldSize and none seem to work....any help here is greatly appreciated.

Thanks

Paul

 

[AncientOne]

You only need to set a field as a number if you are going to perform mathematical operations on it (multiplication, division, exponentiation, etc). Since yiou don't need to do this with credit card numbers, set it as a text field. The same goes for telephone "numbers". Counter-intuitive, I know, but it's the way to do it!

 

[dcx693]

AncientOne is totally right.

If you're interested, here's the Access definition of the long data type:

Long data type
A 4-byte integer ranging in value from -2,147,483,648 to 2,147,483,647. The ampersand (&) type-declaration character represents a Long in Visual Basic.

As you can see, even if you wanted to store your info as numbers, you couldn't use this data type since it "only" holds 10 digits.