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

Show week number in Project Report 0
Auto number in an existing table 4
auto number index snafu 6
Select Record in query, save as New Record then edit New Record 1
Launching Report from Form Only Shows Report for First Record 5
Calculating a value for a new record 2
Access 2003:Basic DB Design 3
Copy record into same table 1

Top