AlphaNumeric serial numbers (1 Viewer)

[Shakesbeer]

I want a field to be a serial number made up of a letter of the alphabet followed by 3 digits. I want the digits to increase by 1 in each of the following record. For Example the serial number in the first record would be A001, then followed by A002, A003, ....., A142, A143, A144 & so on. I am fairly new at Access but I have experimented with AutoNumber, it won't work if the Field is not a pure mumber, can't get autonumbering to happen if I treat the field as text. I don't know where to go from here.

Any help is much appreciated.

Rob Shakesbeer

 

[Moniker]

Use an autonumber, and use formatting to display it how you want it. The autonumber will still display 1, 2, 3, etc. On the format for the control that is showing the autonumber, put "A000" to force the format you want.

 

[Shakesbeer]

Thank you very much. It works just fine and I am pleased to have learned something.

Rob Shakesbeer

 

[Bat17]

But do you need to plan ahead? will you at some stage want to start again with B001 ect.

Peter