By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,203 Members | 1,358 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,203 IT Pros & Developers. It's quick & easy.

Autonumbers above 100

P: 1
Hello everybody

I'm new to Access 2003, making my first database. In Forms, as soon as reached record 100 my Autonumber box reads 1E though the record numbers at the bottom of the screen read correctly. Can anyone explain what 1E means and should I try to alter any settings to get a correct >100 readout.
Sorry if this is a naive question.
John Lewis
Oct 11 '07 #1
Share this Question
Share on Google+
2 Replies


Expert 100+
P: 634
Hello everybody

I'm new to Access 2003, making my first database. In Forms, as soon as reached record 100 my Autonumber box reads 1E though the record numbers at the bottom of the screen read correctly. Can anyone explain what 1E means and should I try to alter any settings to get a correct >100 readout.
Sorry if this is a naive question.
John Lewis
Hi

Have you tried making the control a little wider?

I thing it actualy displays 1E+02 if you could see it, which means 1 times 10 squared, ie 10 with an Exponent of 2

??

MTB
Oct 11 '07 #2

nico5038
Expert 2.5K+
P: 3,072
Just widen the column. The "exponential notation" is used when Access can't display the full number.
To correct the width automatically you can click the bar between the columns when the mousepointer looks like a verticalbar with two arrows in opposite direction. When you select first all columns (when the mousepointer on the headerrow shows a black down arrow), then all columns will be set to "fit".

Nic;o)
Oct 11 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.