format number

  • Thread starter Thread starter Jeff
  • Start date Start date
J

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
 
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.
 
Back
Top