Autonumber Formating Errors

  • Thread starter Thread starter Nano
  • Start date Start date
N

Nano

I have a primary key which is autonumber, I have set its format to
0000. It displays 0001, 0001 and so son but in real its values in 1 as
when I concatenate it will other text say A it gice A1 instead of
A0001. I think I need to change it to text before concatenating. If
this is the case how can I convert it into text and if it is not the
case then how can I correct it?

Thanking you in anticipation.

Regards,
Hasnain Raja
 
Try something like this in your text box:
="A" & Format([ID], "0000")
where ID represents the name of the autonumber field.
 
On Mon, 10 Dec 2007 05:04:22 -0800 (PST), Nano <[email protected]>
wrote:

You have to format it yourself using the Format function:
"A" & Format$(MyAutonumberField, "0000")

-Tom.
 
Back
Top