[AccessD] Last page of Report

What I'd suggest David is do your own page numbering then you can use
me.page=me.pages to do the test at the end. Just Dim a long (lngPage) at the
top of the report, set it to 1 in OnOpen, reset it to 1 in the OnPrint of
the group footer, and then, in the OnPrint of the PageHeader set the visible
page number control to the value of lngPage and increment it by 1. Don't
forget to create an invisible control of = Pages or Access doesn't evaluate
the page count.
--
Andy Lacey
http://www.minstersystems.co.uk




--------- Original Message --------
From: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
To: "accessd at databaseadvisors.com" <accessd at databaseadvisors.com>
Subject: Re: [AccessD] Last page of Report
Date: 05/09/05 07:46


Hi David

Add the page count to another (static) variable before you reset the
page counter.
If you preview the report and browse it, the plot thickens ...

/gustav

>>> newsgrps at dalyn.co.nz 05-09-2005 05:45 >>>
I have a report which I want to have a different text on the last
page. If I can identify that the current page is the last page then
I am able to change the value of a text field in the footer section.

How can I tell if the current page is the last one or not? I can't
use something like

If me.page = me.pages then ...

because me.page is reset back to 1 throughout the report based on one
of the group headers.

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

________________________________________________
Message sent using UebiMiau 2.7.2