Autonumber

N

netadmin

I would like to know if it is possible to have a
autonumber field work to produce the following. I would
like the autonumber to grab the initals of the user from
a text box and add a number sequence to it. Any code
would be appreciated.

Thanks
 
K

Ken Snell

No, the autonumber won't store letters in its field. Add another field to
your table that will hold the user's initials, and then write those initials
into the record when you create the record.

If you want to display the combination of the autonumber value (hint:
autonumber values are best used "in secret" and not shown to users) and the
user's intials, you can always concatenate the two values into a single
string value:

[autonumberfield] & [userinitials]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top