Autonumer field error in a form

  • Thread starter Thread starter ALICIA
  • Start date Start date
A

ALICIA

I have a form that uses an autonumber field from my
table. Numbers 1-9 come out fine, but 10+ show "1E+01"
in the field on my form. In the table, the numbers show
up correctly. What is going on? Thank you in advance
for any assistance you can provide.
 
LOL... Never mind... My box wasn't tall enough to show
the number on the form. Thanks for looking.

Alicia
 
I have a form that uses an autonumber field from my
table. Numbers 1-9 come out fine, but 10+ show "1E+01"
in the field on my form. In the table, the numbers show
up correctly. What is going on? Thank you in advance
for any assistance you can provide.
Click to expand...

Just make the textbox wider. Access will switch to scientific notation
if the number won't fit - this makes sense if you are trying to
display 312331156 in a five-byte wide textbox, and makes NO sense in
your case, but it does it anyway!

As a rule you should NOT display autonumbers; their *only* function
should be to provide an almost-guaranteed unique key. Users should not
see them since they will always have gaps and can become random (e.g.
if you Replicate your database).
 
Back
Top