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

[Jussca]

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.