Custom Autonumber 1

[Devil81]

Hi:
I was just wondering if it were possible to create a custom autonumber field by concationating a peice of text e.g, Job with the autonumber function so each record would come out something like Job1, Job2 etc

Thank you, for any help provided.

 

[MichaelRed]

see faq700-184

If you JUST want the fixed / text to appear, DO NOT see the faq. If you want / need the text to be "meaningful" in the context, the faq may have some use.




MichaelRed

 

[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.