[AccessD] Access 2010 Report footer at Page Bottom

Hi David

How about this?

Create a textbox whose ControlSource is

="Page " & [Page] & " of " & [Pages]

You can make it invisible if you like but it needs to be there.

Then  In the OnFormat of the ReportFooter put this code

If Me.Page <> Me.Pages Then
Cancel = True
End If

The reason you need the textbox is that the Pages property only has a value if
you have a control on the report invoking it.
 
I reckon that should do it.

Cheers

Andy

 

 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David Emerson
Sent: 01 December 2014 04:46
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access 2010 Report footer at Page Bottom


Thanks Charlotte,
I have seen some code by Microsoft for putting it at the bottom of the last
page but it seemed to cover more situations than what I wanted.
Because the text I want is higher than what I want to allow for a page
footer on every page it would waste too much space on all the pages before
the last one.
Back to the drawing board.
Regards
David Emerson
Dalyn Software Ltd
Wellington, New Zealand

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Monday, 1 December 2014 1:48 p.m.
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access 2010 Report footer at Page Bottom

The report footer is always going to print immediately after the report.
If you want it at the bottom of the page, you need to use the page footer.
Alternatively you can put a dummy subreport on the report and force it to a
size that will move the report footer to the bottom. That requires more
care and feeding than it's worth.

Chafrlotte

On Sun, Nov 30, 2014 at 2:40 PM, David Emerson <newsgrps at dalyn.co.nz> wrote:

> Hi Listers,
>>
> Does anyone have some simple code that puts the report footer at the
> bottom of the last page. I don't want to use the page footer section,
> just the report footer section.
>>
> Regards
>
> David Emerson
> Dalyn Software Ltd
> Wellington, New Zealand

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