How to display footer only on 1st page of an access report

[ajaiswal]

Hi
I have 2 issues with a report in Access.Appreciate if someone can help me ASAP on these

1) The report has 3 labels with disclamimer about the report. These labels are in the report footer so they appear only at the end of the report. I want these labels to appear only on the 1st page of the report and not the last page. How can I do so???

2) The report has subtotals when a category ends and another starts. Most of the categories are big enough to break in 2 pages(start from middle of one page and end at the begining of 2nd page).I want to display them on a single page only ie if the category goes over to the next page, there should be a page break at the end of 1st category so that the whole of the next category can be displayed on a single page

Any help would be greately appreciated

Thanks
Anand

 

[Spenney]

1) You could put the labels in a page footer and then format the page footer to only display where the page number is 1. Something like...

Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As Integer)
    If Me.Page > 1 Then
        Me.lblFooter1.Visible = False
        Me.lblFooter2.Visible = False
        Me.lblFooter3.Visible = False
    Else
        Me.lblFooter1.Visible = True
        Me.lblFooter2.Visible = True
        Me.lblFooter3.Visible = True
     End If
End Sub

2) Presumably the sub-total appears in a group footer? Hint: take a look at the 'Force New Page' and 'Keep Together' properties of the group.