Data type of more than 10 degits!

[bomayed]

I'm using a NUMBER as a primary Key in my table. But the Primary key that I want to add now is more than 10 degits. AND whenever I try to add more than 10 degits , Access won't allow me

I can't change the Data type of the primary key to MEMO because of the relationship between this table and another table!

I tried , Single , Double , . . . every thing in that list, still didn't work!

Does anyone know what I should do to use more than 10 degits in my Table?

 

[swaybright]

From MS Access Help:
"[Double] stores numbers from
–1.79769313486231E308 to
–4.94065645841247E–324 for negative values and from 1.79769313486231E308 to 4.94065645841247E–324 for positive values."

The number will be written as an exponent for numbers over 10 digits

Shane

 

[Golom]

Does it need to be a numeric at all?

That is, do you do any computations on the value? If you're just using it as a record key then make it a Text data type with whatever length you want up to 255 characters. The fact that the values are composed of numeric digits is not really relevant.