format number

[Jeff]

I'm attempting to preface each page number with a unique ID. The format needs to be as follows:

KeyID_0000001,KeyID_0000002,KeyID_0000003 etc...

It must always contain 13 characters and must be sequetial. I'm having difficulties prefacing the numbers with the preceeding zero's.


Thanks,


Jeff

 

[Allen Browne]

Set the Control Source of the text box on your form to:
="KeyID_" & Format([Page], "0000000")

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I'm attempting to preface each page number with a unique ID. The format
needs to be as follows:

KeyID_0000001,KeyID_0000002,KeyID_0000003 etc...

It must always contain 13 characters and must be sequetial. I'm having
difficulties prefacing the numbers with the preceeding zero's.