FieldSize in Number Fields

[l_gilliver]

What is the longest string of numbers that you can have in a Number Field.
I have an eBay database I have created and it was fine inputting the item #
into the field until the item #'s have reached 12 numbers long. Now, when i
put the data in it automatically changes it to be scientific mode even though
the field is set to be in general.
For example

original number = 320003721207

Access changes it to = 3.20003721207E+11

Can anyone help?

 

[John Vinson]

What is the longest string of numbers that you can have in a Number Field.
I have an eBay database I have created and it was fine inputting the item #
into the field until the item #'s have reached 12 numbers long. Now, when i
put the data in it automatically changes it to be scientific mode even though
the field is set to be in general.
For example

original number = 320003721207

Access changes it to = 3.20003721207E+11

Can anyone help?

If the "number" is being used as an identifier rather than for
mathematical calculations, use a Text datatype rather than any sort of
Number. Long Integers are limited to up to two billion odd (2^31 - 1),
Doubles to 13 or 14 decimal places.


John W. Vinson[MVP]

 

[fredg]

What is the longest string of numbers that you can have in a Number Field.
I have an eBay database I have created and it was fine inputting the item #
into the field until the item #'s have reached 12 numbers long. Now, when i
put the data in it automatically changes it to be scientific mode even though
the field is set to be in general.
For example

original number = 320003721207

Access changes it to = 3.20003721207E+11

Can anyone help?

Are you ever going to add Item# 320003721207 + Item# 320003721208 ?
Of course not.
Change the field datatype to Text and you won't have to worry about
the length of the field. Set the Field Size to 255.