Is it possible to print the page in a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to print page no. in a reports
generated thru' using Access reports.
How to do it? Is it possible to print
something like page 1 of 15, 2 of 15, etc.

Thank you,
-M
 
From my file - see below my Sig line!

Put the expression in the controlsource of a textbox in your report's page
footer.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

Examples Of Expressions For Page Numbers

The following table lists examples of page number expressions you can use in
form or report Design view and the results that you see in other views.

Expression Result

=[Page] 1, 2, 3

="Page " & [Page] Page 1, Page 2, Page 3

="Page " & [Page] & " of " & [Pages] Page 1 of 3, Page 2 of 3, Page 3 of 3

=[Page] & " of " & [Pages] & " Pages" 1 of 3 Pages, 2 of 3 Pages, 3 of 3
Pages

=[Page] & "/"& [Pages] & " Pages" 1/3 Pages, 2/3 Pages, 3/3 Pages

=[Country] & " - " & [Page] UK - 1, UK - 2, UK - 3

=Format([Page], "000") 001, 002, 003
 
Add a text box where you want the page number to print. Set its Control
Source property to

="Page " & [Page] & " of " & [Pages]

To save having to type that, click on the ellipses (...) to the right of the
Control Source box on the Property Sheet. In the Expression Builder dialog
box that appears, select the Common Expressions folder on the left hand
side. Select the Page N of M option, then click on the Paste button.
 
Doug,

Thanks a lot!
-M

Douglas J. Steele said:
Add a text box where you want the page number to print. Set its Control
Source property to

="Page " & [Page] & " of " & [Pages]

To save having to type that, click on the ellipses (...) to the right of the
Control Source box on the Property Sheet. In the Expression Builder dialog
box that appears, select the Common Expressions folder on the left hand
side. Select the Page N of M option, then click on the Paste button.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



Me said:
I would like to print page no. in a reports
generated thru' using Access reports.
How to do it? Is it possible to print
something like page 1 of 15, 2 of 15, etc.

Thank you,
-M
Click to expand...
Click to expand...
 
Thank you,
-M

PC Datasheet said:
From my file - see below my Sig line!

Put the expression in the controlsource of a textbox in your report's page
footer.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

Examples Of Expressions For Page Numbers

The following table lists examples of page number expressions you can use in
form or report Design view and the results that you see in other views.

Expression Result

=[Page] 1, 2, 3

="Page " & [Page] Page 1, Page 2, Page 3

="Page " & [Page] & " of " & [Pages] Page 1 of 3, Page 2 of 3, Page 3 of 3

=[Page] & " of " & [Pages] & " Pages" 1 of 3 Pages, 2 of 3 Pages, 3 of 3
Pages

=[Page] & "/"& [Pages] & " Pages" 1/3 Pages, 2/3 Pages, 3/3 Pages

=[Country] & " - " & [Page] UK - 1, UK - 2, UK - 3

=Format([Page], "000") 001, 002, 003



Me said:
I would like to print page no. in a reports
generated thru' using Access reports.
How to do it? Is it possible to print
something like page 1 of 15, 2 of 15, etc.

Thank you,
-M
Click to expand...
Click to expand...
 
Back
Top