Adding Prefix to AutoNumber

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:

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.

Return from Adding Prefix to AutoNumber to Simply Access Home Page

or

Return to Microsoft Access Tables