CHANGING A FIELD

[Pat]

Is it possible to change a field from a number to an autonumber after records
have been added. If so, please provide step by step instructions!!
I have a donation table that I enter each receipt number (consecutively), it
would be better if the table was set up to do this on its own thereby not
missing a sequence by mistake.

 

[Pat]

That was easy and awesome, thank you.

 

[John Spencer MVP]

However, you should be aware that autonumbers will develop gaps in the
sequence and can (in certain circumstances) start generating numbers that are
not sequential at all.

If having an unbroken sequence is important then you need to use a long
integer number field and you need to use VBA code to generate the numbers.

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