Autonumber

  • Thread starter Thread starter netadmin
  • Start date Start date
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
 
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]
 
Back
Top