Autonumber

[Kerry Purdy]

Hi,

How can I set my autonumber to be 4 characters please so as not to look
silly as a PO number e.g. 0001...0010...0100...etc instead of 1.

Many thanks

 

[fredg]

Hi,

How can I set my autonumber to be 4 characters please so as not to look
silly as a PO number e.g. 0001...0010...0100...etc instead of 1.

Many thanks

"Set" the autonumber?
You can't. As a number value 0001 is the same as 1 and Access will not
save preceding zeros in a Number datatype field.

Display the autonumber?
Set the control's Format property to:
0000

What do you intend to do when the autonumber field value gets to 9999?
Note: An AutoNumber field is designed only to be unique, and not
necessarily consecutive.
If (as it appears it does in you message) the autonumber has meaning
(other than being unique), you should not be using it in this manner.
Create your own counter field (incrementing it by 1 after you add each
new record) and assign that value +1 to each new invoice record. Use
the same Format property as indicated above to display it with 4
digits. Keep the autonumber field as the unique record identifier.