Adding Prefix to AutoNumber

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:

ABC001

ABC002

Etc.

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:

“ABC”000

Now the prefix and the corresponding zeros will be included with each of your AutoNumbers.