Numbering Problem

[christine]

I am working on a database and have numbered the rows starting at 1. When I
reached 100 the numbers started displaying as 1E+ 02 and continues with
similiar figures. I don't know why this happened and can't figure out how to
have the numbers show in normal figures such as 100, 101, 102, etc. Thank you
for any help.

 

[BruceM]

It is not about the column width. Most likely you need to open the table in
design view and change the field's format to something other than
Scientific.

 

[BruceM]

On another point, if you are entering data directly in a table, it would be
best if you don't. Use a form instead. If you were talking about a form in
your original posting, check the text box format as well as the table format
if you continue to have the problem.
Access can number the rows (records) automatically, if that's what you need.
This sample database shows you one way to do that:
http://www.rogersaccesslibrary.com/...?TID=395&SID=5cc2b554za3887d3ee2bez38822zc76f
That link is all on one line. It may be simpler to go here:
http://www.rogersaccesslibrary.com/forum/forum_topics.asp?FID=1
and choose "AutonumberProblem.mdb"

 

[John Spencer]

Bruce,
If the user is entering data directly into a table or viewing data directly in
the table, she will see scientific notation for the number if it is too narrow
to display the value. The same behavior can be seen on a form and in a report.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[BruceM]

I should have added a caveat. Since the OP seems to be able to see the full
value I assumed the full value was visible, but it is possible she was using
the arrow keys or something to get from left to right. Had I read the
question more carefully I would have noted that the numbers before 100 seem
to be OK, which I do not think would have been the case with scientific
notation. I must say I am mystified that the OP seems somehow to have made
the column very narrow, which I do not think would have happened by default
even with a very short field name, yet did not make the field wider when all
of the data in the field could not be seen. Anyhow, thanks for the
feedback.

 

[BruceM]

See my reply to John. As I acknowledged, I seem to have erred.

 

[christine]

I made my column wider.....problem solved! Thank you Chris. I spent forever
trying to figure out what happened....frustrating that it was something so
simple. Thanks again.