Remove Page Footer when Report footer is shown

[UHNSTrust]

I want to be able to hide the page footer when the report footer is on the page. Any ideas?

The reason is that on the page footer I have a 'Key' for the report that could span multiple pages if there are enough records. What I then have set up is the Force New Page as Before Section on the report footer. The problem is the Key is printing on the page with the report footer although the information on that page does not need the Key.

Thanks in advance

Jonathan

 

[dhookom]

You might be able to add code to the On Format event of the Page Footer section:

    Cancel =([Page]=[Pages])

This may require adding a text box bound to [pages] in your report.

Duane
Hook'D on Access
MS Access MVP

 

[Remou]

If you look at the report properties, you should find the Page Footer property, which will allow you to select "Not With Rpt Footer", amongst other options.

 

[UHNSTrust]

Remou and Dhookam,

Thanks for the reply. Went with Remou's suggestion in the end as it seemed easier to implement.

Jonathan