Alter number of pages

[Bob Howard]

I have a report formatted as a "booklet." The cover is the result of the
report header section being made just big enough to completely fill the
first page.

After that, the data prints.

I have a page footer with some date information and the page numbers (page x
or y) --- this section is definied Visible=No. I set it to "true" (i.e.,
"Yes") in an OnPrint event for the first group of data. That's working
fine --- the page footer is not printing on the cover page but it is
printing on the other pages.

In that same OnPrint event, I also reset the page number to 1 so that the
first data page shows page number 1. But the "Pages" is a read-only
property and I cannot reset that also. It alsways is taking into account
the "extra" page that is the cover. So a report containing 4 data pages are
numbered "1 of 5" through "4 of 5" --- looks really wierd! Makes it look
like the report is missing the last page!

Is there any way I can reset the "pages" so that I can simply redue it by 1?
Or other ideas?

Bob (@Martureo.Org)

 

[Duane Hookom]

Consider subtracting 1 from Pages.
="Page " & [Page] & " of " & [Pages]-1

 

[Bob Howard]

Duane ---

I'm so sorry about asking such a stupid question! Mine has turned out to be
such a complex application that i tend to think of all pieces as being
"tough" to implement. But the solution came to me only seconds after I hit
the "Send" key and I really felt like a jerk.

Thanks for putting up with me!

Bob.

Consider subtracting 1 from Pages.
="Page " & [Page] & " of " & [Pages]-1

--
Duane Hookom
MS Access MVP

I have a report formatted as a "booklet." The cover is the result of the
report header section being made just big enough to completely fill the
first page.

After that, the data prints.

I have a page footer with some date information and the page numbers (page
x
or y) --- this section is definied Visible=No. I set it to "true" (i.e.,
"Yes") in an OnPrint event for the first group of data. That's working
fine --- the page footer is not printing on the cover page but it is
printing on the other pages.

In that same OnPrint event, I also reset the page number to 1 so that the
first data page shows page number 1. But the "Pages" is a read-only
property and I cannot reset that also. It alsways is taking into account
the "extra" page that is the cover. So a report containing 4 data pages
are
numbered "1 of 5" through "4 of 5" --- looks really wierd! Makes it look
like the report is missing the last page!

Is there any way I can reset the "pages" so that I can simply redue it by
1?
Or other ideas?

Bob (@Martureo.Org)