more than 10000 records in a DB and showing record number

  • Thread starter Thread starter Michael Linke
  • Start date Start date
M

Michael Linke

I have a db, now with over 10000 records. The record id
field in the form is showing at 1E+04, it went form 9999
to this.

The field is an auto number field so there is no way of
changing its format.

What can i do to ensure the field shows the full five
digits of the record number.

Thanks

M
 
1E+04 is 1 * 10^4 which is 10,000 so it is correct.

Check the Format you use on the Control bound to this
Field (or the Field in the Table design). You probably has
some format that doesn't work well with number with more
than 4 digits.

HTH
Van T. Dinh
MVP (Access)
 
I suspect that the field you're using to display is too narrow. Widen it,
and you should get the normal display.
 
Back
Top