need help with page footer 1

[SmallTime]

I have a main report containing a number of sub reports which both have fields that can grow depending on the amount of text the field is populated with. So the report can be from one page long to any number.

What I need to do, but can't seem to achieve, is to have a page footer on the 1st page ONLY of the main report. Having looked at the available properties it seems I can show a page footer almost everywhere else apart from where I need it, with the head only.

Any ideas would be greatly appreciated.

 

[dhookom]

You could probably use code in the On Format event of the Page Footer like:

Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As Integer)
    Cancel = Page <> 1
End Sub

THis assumes you have a Page of Pages control on your report.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[SmallTime]

Many thanks. Works beautifully