Re: Prefix to Autonumber

Oops. Quote was in the wrong place in the first suggestion:
"2MER"00000
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx> wrote in message
news:46986558$0$12840$5a62ac22@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
If all records have the same prefix (i.e. 2MER), you can display this on a form or report by setting the Format property of your text box to:
"2MER0"0000

Alternatively, set the Control Source of a text box to:
="2MER" & Format([ID], "00000")
substituting your field name for ID.

"feeman" <feehally128@xxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:1184391044.723754.193540@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I have a table stores records for moving stock around to different
sites, we use a unique number for this paperwork, it stats with 2MER
and then it has sequential numbering after this. Is there a way that
the field in my database can have the 2MER and then the autonumber
after it, if so how is it done. So it will read 2MER00234, then
2MER00235 and so on.

.

Relevant Pages