Autonumber Formating Errors

[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

 

[Allen Browne]

Try something like this in your text box:
="A" & Format([ID], "0000")
where ID represents the name of the autonumber field.

 

[Tom van Stiphout]

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.