Toggle Visibility of Group Header/Footer Based on Criteria?

[evander]

Hi.

I'm back! I'm glad to become a member of this site so I can obtain answers for my Access questions.

The problem is, my Access 2003 code no longer works in 2007:

Private Sub GroupFooter1_Format(Cancel As Integer, FormatCount As Integer)
    If AccountCategoryCode = 9000 Then
        GroupFooter2.Visible = False
    End If
End Sub

What this code does is hide the groupfooter2 if I meet a certain condition.
I don't know how to solve this. Please help. Thanks.

Jan

[evander]

Sorry for the typo, groupfooter1.visible = false. Still it doesn't work.

[evander]

Okay something weird's going on. This is in Access 2007. When I view the report in "Preview" mode, the report sections gets nicely hidden. But when I view the report in "Report" mode, all sections are displayed, even though the report fields meet a certain criteria to hide these sections.

[evander]

Allen Browne says, "The events of the report's sections do not fire in this view."
What the crap