Re: Prefix to Autonumber

Try setting the Format property of the text box as shown.

--
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.
"feeman" <feehally128@xxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:1184393945.826714.182780@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Jul 14, 6:58 am, "Allen Browne" <AllenBro...@xxxxxxxxxxxxxx> wrote:
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" <AllenBro...@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" <feehally...@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.- Hide quoted text -

- Show quoted text

Thanks for that, if I have already entered a lot of data and now need
it to do the above but need it to start at number 01256 and then start
the autonumbering, how can i do this please.


.

Relevant Pages