|
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.
Do you like this tip? Subscribe to my weekly Newsletter to receive tips
weekly via email.
Click Here to subscribe.
|
