Is it possible to change the starting number in Auto Number?

[Guest]

I'm creating a billing invoice and using the Auto Number feature. It is
possible to change the starting number (eg. from 1 to 0001)?

 

[Rick B]

Do a search and read the previous posts. Asked and answered all the time.
You should not use an autonumber field for this.

 

[Lynn Trapp]

As far as Access is concerned there is no difference between 1 and 0001 in
an AutoNumber field. You can, however, format the field to be displayed with
leading zeros. Put 0000 in the format section of your field in table
design.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Rick B]

Oops. I read your original post as 1 and 1000.

Lynn's post is more appropriate.

But, you still can find a hundred previous posts out there related to
formatting a number with leading zeros.

 

[fredg]

I'm creating a billing invoice and using the Auto Number feature. It is
possible to change the starting number (eg. from 1 to 0001)?

You should not be using an AutoNumber field for anything other than
assuring that each record's ID is unique.

If you wish to assign an Invoice number in a consecutive fashion,
create your own InvoiceNum field.
You can make it Number datatype, Integer field size.

Then increment it on your form in the InvoiceNum control's Default
Value property:
Nz(DMax("[InvoiceNum]","TableName"),0) + 1

Set the Format property of the field to:
0000

and it will display as 0001, 0002, etc.

 

[Joseph Meehan]

I'm creating a billing invoice and using the Auto Number feature. It
is possible to change the starting number (eg. from 1 to 0001)?

Others have already addressed the leading zero issue. Now about
autonumbers where you or anyone will be looking at the numbers. Be aware
that autonumber is designed to provide unique numbers. It is not designed
to produce consecutive numbers, although it will do it most of the time.

When people start looking at the list and see numbers missing or out of
order, they are going to think they have a problem.

You can create a system to give consecutive numbers if you like.