change page expression to sheet with preceding 00

[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

 

[Klatuu]

Try "Sheet" & Format([Page], "000")

 

[Kelly]

Thanks Dave that worked great!!!!
Kelly

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

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