This tip Adding Prefix to AutoNumber is suitable for all versions of Microsoft Access.
This tip will explain about adding a prefix to an autonumber field.
An AutoNumber field is great as it automatically increases for you. There are times though when you need a prefix before it. For this example our prefix is ABC and we want the number to display as:
You can easily set this up.
When creating your table and defining the field type as an AutoNumber field, click on the ‘General’ tab in the bottom half of the table design window. One of the properties listed here is ‘Format’.
In here, type the following:
Now the prefix and the corresponding zeros will be included with each of your AutoNumbers.