Text Autonumber

[Ken Wilson]

I would really appreciate it someone could help me out, with this particular
issue regarding MS-Access table autonumber.

As I believe the autonumber only generates numaric values. My preference is
to have Text values instead.

I would really appreciate it if someone could guide me towards accomplishing
the above stated task.

 

[Tim Ferguson]

As I believe the autonumber only generates numaric values. My
preference is to have Text values instead.

In that case, an autonumber will not do.

Remember that ANs have a fairly limited repertoire: they guarantee[1] to
provide a number that is unique for each record. They are not sequential,
they do not make good record counters, they will not look pretty to
users.

If you have some special way of allocating your text identifiers, then
you can probably write some VBA to do it automatically. If you don't,
then you probably need to post in comp.databases.ms-access.telepathy <g>

One note though: except for _very_ short strings, numeric identifiers do
allow the db engine to work much more efficiently.

HTH


Tim F