How do I make an autonumber alphanumeric.. 1

[fmasin]

Hi,

How can I make an autonumber alphanumeric? say for example...instead of 1, I could have OCH001A....etc..?

Thanks and regards,

Francis

 

[PHV]

A quick'n'dirty search in the access FAQs:

http://www.tek-tips.com/faqs.cfm?fid=5106

http://www.tek-tips.com/faqs.cfm?fid=1179

http://www.tek-tips.com/faqs.cfm?fid=1725

http://www.tek-tips.com/faqs.cfm?fid=184

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[fneily]

Let’s say you want an autonumbered field by Microsoft but want some characters in front of the number like mc001, mc002, etc. Go to design view, click on the autonumber field and in the Format box type “mc”00
This places mc next to 2 zeros and then tacks on the autonumber.