Number of Pages

[Lamar]

I have a form where user enter payment history information about our clients
and then a "Payment History" report (rptPaymentHistory) is automatically sent
to the clients. Depending on the client the number of pages for
rptPaymentHistory varies.

I have text box (txtPageNumber) on my form that I want to automatically
capture the number of pages for rptPaymentHistory. We bill the client by
number of pages.

The user inputting information never sees the report. After the client info
is entered then is there a way to know how many pages of rptPaymentHistory?
Besides having to manual open rptPaymentHistory and then have the user enter
the number of pages in the text box.

 

[Tom Lake]

The user inputting information never sees the report. After the client

info
is entered then is there a way to know how many pages of
rptPaymentHistory?
Besides having to manual open rptPaymentHistory and then have the user
enter
the number of pages in the text box.

The [Pages] variable holds the complete number of pages for a report.

Tom Lake

 

[Lamar]

Yes, but how do I get the text box on form to show the number of pages of
the report without "previewing" the report first.

The user inputting information never sees the report. After the client
info
is entered then is there a way to know how many pages of
rptPaymentHistory?
Besides having to manual open rptPaymentHistory and then have the user
enter
the number of pages in the text box.

The [Pages] variable holds the complete number of pages for a report.

Tom Lake

 

[Rick Brandt]

Yes, but how do I get the text box on form to show the number of
pages of the report without "previewing" the report first.

You can't. The report doesn;t even know that value until it has processed
the report. Displaying [pages] pon a report actually causes the report to
be processed twice. Once so that the pages value can be determined and then
it goes back and does it again.