ID Autonumbers stopped at 104 and now lists as E+105. Why?

[Scotchbelle]

I'm working on a small database. For some reason the Autonumbers stopped
increasing at 104 and from then on all new entrants were recorded as ID
E+105. Can anyone help me to sort this out so they read 105, 106. 107 and so
on?

 

[Rick Brandt]

I'm working on a small database. For some reason the Autonumbers stopped
increasing at 104 and from then on all new entrants were recorded as ID
E+105. Can anyone help me to sort this out so they read 105, 106. 107 and so
on?

When Access uses the E+ notation it simply means the column is too narrow to
display the number normally.

Standard AutoNumber caveat: If you care about the value in ANY way other than
uniqueness, then don't use an AutoNumber. They will develop gaps and can on
occasion make large jumps or even go negative. Their ONLY purpose is to provide
a unique key for linking tables or to act as a surrogate Primary Key.