How do I make a footer section conditional?

[dfwelch]

I need to know the VB syntax to make a section footer NOT appear based on the value of a field, call it FooterFlag, a boolean field. So, whenever FooterFlag is true, I want the section footer to NOT appear.

 

[CosmoKramer]

In the On Format event of the group footer, place code like this:

If Me.FooterFlag = -1 Then
   Cancel = True
End If

Hoc nomen meum verum non est.

 

[sucoyant]

This is a good thing to know. Thanks

----------------------------------------
Buddha. Dharma. Sangha.