Auto numbers over 100 display incorrectly in report

  • Thread starter Katherine Smith
  • Start date
K

Katherine Smith

I now have over 100 entries in my database. On this forms and tables this
shows as 1 through to 113 but when I print a report it displays as 1 through
to 99 and all records after that are displayed as 1E+02. How can I sort this
so my reports show the correct auto numbers?
 
A

Allen Browne

Make the text box wider.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...
 
K

Klatuu

As Allen says, making the text box wider will accomplish what you want.

But, I would like to offer some advice on the use of Autonumber fields.
They should never be seen by a user and should never be used for anything
meaningful. They are designed to be used only as surrogate primary keys to
relate records in other tables.

You cannot expect them to be sequential without gaps. If a record is
started, but never saved, the number originally assigned is discarded.
 

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

Numbers over 100 print funny 2
same report displays in 2003 but not in 2007 2
Report/subreport display 3
Access Access Report Works on One Machine but not Another 3
Resetting report page numbers 2
Multiple reports in a report 3
Pie Chart will only Display one slice - 100% 1
Slow report 3

Top