Page numbering

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

Guest

I'm using Access 2002. Is there a way to suppress printing the page number on
the first page and begin printing the page number (beginning with #1) on what
is actually page 2? I have set up a cover page for my report as the report
header and I don't want the page number to print on this page. Any
suggestions? Thanks so much for your help!
 
VickiS said:
I'm using Access 2002. Is there a way to suppress printing the page number on
the first page and begin printing the page number (beginning with #1) on what
is actually page 2? I have set up a cover page for my report as the report
header and I don't want the page number to print on this page. Any
suggestions?
Click to expand...


Set the page number text box's expression to

=Page - 1

and set its Format property to 0;;" "
 
--
VickiS


Marshall Barton said:
Set the page number text box's expression to

=Page - 1

and set its Format property to 0;;" "
Click to expand...
How do I do that when I'm printing the total # of pages: ="Page " & [Page]
& " of " & [Pages]

Thanks for your quick response!
 
On Wed, 2 Nov 2005 15:23:02 -0800, VickiS wrote:

VickiS


Marshall Barton said:
VickiS said:
I'm using Access 2002. Is there a way to suppress printing the page number on
the first page and begin printing the page number (beginning with #1) on what
is actually page 2? I have set up a cover page for my report as the report
header and I don't want the page number to print on this page. Any
suggestions?
Click to expand...


Set the page number text box's expression to

=Page - 1

and set its Format property to 0;;" "

--
Marsh
MVP [MS Access]

How do I do that when I'm printing the total # of pages: ="Page " & [Page]
Click to expand...
& " of " & [Pages]
Thanks for your quick response!
Click to expand...

Any reason why you didn't mention that in your original post?

In the Report Header Format event:
Me.[Page] = 0

Code the Page Header Format event:
Me.[NameOfControlThatShowsThePage].Visible = Me.[Page] >0

Since the page count will start at 0, you'll also need to change the
control source (assuming you do not wish to count the first page):
= "Page " & [Page] & " of " & [Pages]-1
 
Back
Top