I have a report, where I only want to print a particular footer when a condition is met. In the footer's properties "On Format" event, I have entered code that sets the footer's VISIBLE property to either True or False. When I generate this report, I see "Page 1 of 3", then sometimes, "Page 1 of 5"... in both cases the report is 4 pages long. I am guessing that Access is not taking into account, the "On Format" logic affecting the VISIBLE property... when making its first pass through the report, in order to calc the "of x" value?

Any ideas...?

Whether or not the footer is visible, and then what page is actually showing are two different problems. First, is the footer disappearing when it's supposed to? What is your criteria? May we see the code?

Second, if it appears when it's supposed to but the numbering is wrong, then that's another issue. Remember that each time you open your report with a filter, the number of pages is supposed to change.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

The footer is appearing when it should, and should not. The criteria for making the footer visible is based on a variable count of records within the record group. The code is as follows:

Private Sub ClientCodeFooter_Format(Cancel As Integer, FormatCount As Integer)

    If StaffCount <= 1 Then
        Me.ClientCodeFooter.Visible = False
    Else
        Me.ClientCodeFooter.Visible = True
    End If

End Sub

There is no filter involved, per se; the report is based on a query, which when I tested remained constant.

The only issue is why the "of pages" would be wrong (and sometimes different) given the input and output.

I thought there may be a correlation between the visible/non-visible footer and pages miscalculation because the report is 3 pages long with no printing of the footer and 5 pages with printing of the footer. The report actually is a combination of the two.

Thanks.