Hello,

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.

Many Thanks
Andy

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

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.

Cheers Van,

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

End Sub

Thanks Peter,

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?

Many Thanks
Andy