Change Automatic ID Field?

C

C#Newbie01

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,
 
J

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,
Click to expand...

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]
 
Top