Apr 23 2008, 04:14 AM
I have a report that has a page footer that I display on the first page only.
Is it then possible to display a different footer on all other pages?
I have searched through the forum but have been unable to find anything that works for me.
Apr 23 2008, 05:24 AM
The only way I can think of doing that would be to build one footer section which contains all the controls from both versions of the footer, and then use the .visible property of each control to make some visible and some invisible depending on the page number.
In the page footer print event you would have stuff like:
me.textbox1.visible = (Page =1) ' visible only on page 1
me.textbox2.visible = (page<>1) ' visible on page2 onwards
Apr 23 2008, 05:26 AM
There is only one Page Footer Section in Access Report. However, you can use the PageFooter_Format Event with the Page Property to perform some actions on the Controls in the PageFooter section, e.g. show/hide Controls in the PageFooter.
Apr 23 2008, 06:13 AM
I am using the OnFormat Event to only display the footer on the first page with;
Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As Integer)
If Page <> 1 Then Me.PrintSection = False
I shall try using this method, altough there are a lot of controls and lines in my footer so it will take some time.
I will let you know how I get on.
Also do you know how I can get rid of the empty space that is left on the other pages when the footer is hidden?
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here