hiding group footer

[stumbler]

i'm trying to hide a group footer at the moment when a c ertain calculated value is zero.

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

    If Me!qtyYear = 0 Then
        Me.Groupfooter2.visible = False
    Else
        Me.Groupfooter2.visible = True
    End If

End Sub

but nothing is hidden even if value is 0 for the group

Any Ideas?

 

[JHB]

It wooks for me, are you sure the If condition for Me!qtyYear = 0 is fired? (Put in a breakpoint).

 

[stumbler]

seems the 'group' events are only triggering when you open the report in print or print preview mode, not when you click on the green report icon
so it was my mistake