change page expression to sheet with preceding 00

  • Thread starter Thread starter Kelly
  • Start date Start date
K

Kelly

Does anyone know how I can change the ="Page " & [Page] expression to show
Sheet instead. The ="Page " & [Page] shows on the report as Page 1 and
changes with each page. I need to be able to show it as Sheet 001, Sheet 002
and so on. I tried just changing to ="Sheet " & [Page] but don't know how to
get the 00 to keep a three character field at all times.

Kelly
 
Thanks Dave that worked great!!!!
Kelly


Klatuu said:
Try "Sheet" & Format([Page], "000")
--
Dave Hargis, Microsoft Access MVP


Kelly said:
Does anyone know how I can change the ="Page " & [Page] expression to show
Sheet instead. The ="Page " & [Page] shows on the report as Page 1 and
changes with each page. I need to be able to show it as Sheet 001, Sheet 002
and so on. I tried just changing to ="Sheet " & [Page] but don't know how to
get the 00 to keep a three character field at all times.

Kelly
Click to expand...
Click to expand...
 
Back
Top