Change Automatic ID Field?

[Guest]

Hello, I could do this with SQL, but haven't found a way to do this with
Access 2007 (And have to imagine this is supported). Presently the ID Field
starts at "1". I would like the Automatic ID Field to start at four digits,
such as "0001". How can I make this change? I really appreciate the help.

Thank you,

 

[Allen Browne]

See:
Set AutoNumbers to start from ...
at:
http://allenbrowne.com/ser-26.html

 

[John W. Vinson]

Hello, I could do this with SQL, but haven't found a way to do this with
Access 2007 (And have to imagine this is supported). Presently the ID Field
starts at "1". I would like the Automatic ID Field to start at four digits,
such as "0001". How can I make this change? I really appreciate the help.

Thank you,

A Number is just a number: as a number, 1 and 0001 and 000000000001 are all
exactly the same number.

You can *display* the number with leading zeros by setting a Form or Report's
Format property to

"0000"

You can even set the Table field format the same way... but I'd recommend not
using table datasheets for routine interaction with data; forms are much more
controllable, powerful and flexible.

John W. Vinson [MVP]