Page numbering

  • Thread starter Thread starter Ellen
  • Start date Start date
E

Ellen

Hello,
I've made a simple report in Access 97, which has a cover
sheet. I've made this cover sheet by adding a page break
at the bottom of the report header. Having done that, I'd
like the page numbering to start at the first page
containing data, which would be the page following the
cover sheet. Thus far the best I've been able to do is for
the page numbering to start with page 2 (the second page
with data).

Can anyone tell me how that would be done?

Thanks in advance for your help.

Ellen
 
Ellen,

In the page numbering text box that Access creates in the page footer by
default (or in anohter text box if you have deleted that), change the
default expression in the controlsource property (="Page " & [Page] & " of
" & [Pages]) to:

=Iif([Page] = 1, "","Page " & [Page] -1 & " of " & [Pages] -1)

HTH,
Nikos
 
You could just subtract 1 from the Page property, so your text box reads:
=[Page] - 1

If you need something more complex, it is possible to reassign a value to
the report's Page property.
 
Thanks, Nikos! And I've figured out how to also follow
suit with the date on the footer, with:
=IIf([Page]=1,"",Now())
-----Original Message-----
Ellen,

In the page numbering text box that Access creates in the page footer by
default (or in anohter text box if you have deleted that), change the
default expression in the controlsource property (="Page " & [Page] & " of
" & [Pages]) to:

=Iif([Page] = 1, "","Page " & [Page] -1 & " of " & [Pages] -1)

HTH,
Nikos

Hello,
I've made a simple report in Access 97, which has a cover
sheet. I've made this cover sheet by adding a page break
at the bottom of the report header. Having done that, I'd
like the page numbering to start at the first page
containing data, which would be the page following the
cover sheet. Thus far the best I've been able to do is for
the page numbering to start with page 2 (the second page
with data).

Can anyone tell me how that would be done?

Thanks in advance for your help.

Ellen
Click to expand...


.
Click to expand...
 
Back
Top