You can create your own number/numbering scheme, if you wish.
But auto-numbers are, by definition, long integers that are automatically
updated by Access. They are only intended to be unique (not, as some assume,
monotonically increasing), used internally in applications for identifying
and linking data, and they are not intended for display to users.
If you feel _compelled_ to use the autonumber for whatever your purposes
are, store separately the letter prefix and append them together when you
need to use them.
But, I caution you, the "green eyeshade crowd" from accounting and auditing
are going to raise cain with you when someone starts to create a new record,
cancels, and that autonumber is lost, so there is a "gap" in the numbers.
Larry Linson
Microsoft Access MVP
