more than 10000 records in a DB and showing record number

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
 
V

Van T. Dinh

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)
 
D

Douglas J. Steele

I suspect that the field you're using to display is too narrow. Widen it,
and you should get the normal display.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
auto number index snafu 6
Data Entry Form and Auto Number ID 2
passing record number to a form.. 2
Auto number in an existing table 4
Multiple records that contain a checkbox.One record should be chec 4
auto-numbering records in a sub-table 4
Problem with Autonumbers affecting more than just new record 3

Top