reset increment number in datatype

[Guest]

how can reset increment number in datatype when it is set auto number.
Everytime i deleted a record ,my field name call ID does not erase auto
number, but keeps jumping to next ID number?

 

[John Vinson]

how can reset increment number in datatype when it is set auto number.
Everytime i deleted a record ,my field name call ID does not erase auto
number, but keeps jumping to next ID number?

That's the purpose of autonumbers. The autonumber is designed for one
purpose, and one purpose only: to provide a unique key.

You cannot and should not assume that autonumbers are sequential, or
free of gaps; in general, you're best off not exposing autonumbers to
the user at all! Instead, you can use a Long Integer value and assign
its value in VBA code.

John W. Vinson[MVP]