Prefix Autonumber

[ahuvas]

I found instructions that said in order to prefix an autonumber i.e. AAA000 you would have to write "AAA"000 in the format section under the general tab in the table design view of the field you are interested in.

I did this however even though the number now appears as AAA000, AAA001 etc in the table it does appear this way in the form - it just appears as 0,1 etc....

My actual prefix is 2006/1010/ i.e. 2006/1010/001, 2006/1010/002 and so forth.

Anyone have an idea of why not?

 

[DJkarl]

A format changes the appearance of the data, but not the actual data itself. You have a format on the table so when you are viewing the table directly the data appears as you want, put the same format on the form and the data should appear the way you want it to.