No, you cannot reset the autonumber so it won't have gaps. Once a number has
been used it is no longer available. If you start to add a record and then
cancel, that number is used up. If you delete a record, the number has been
used and is no longer available.
Autonumber's primary purpose is to generate a unique number for the record
that cannot be duplicated and can be used as a primary key field. It is
rarely appropriate to show that number to a user.
If you need a sequential number with no gaps, you will have to develop some
vba to generate the number. And if you plan on deleting records, your system
will need a way to spot the gaps in the sequence and re-issue the number.
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County