Set VISIBLE property of sub detail group footer to NO in ACCESS 1

[kjenkinz]

I want to set a the VISIBLE property of one of my sub-detail footer lines to NO based on the value of a field. For instance, I am sub-totaling on a group, lets say the groups are A and B. When the [GrpTyp] field="B", I don't want to show the sub-total footer. How do I do that?

Thanks!

 

[CosmoKramer]

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

If Me.GrpTyp field = "B" Then
   Me.txtSubTotal.Visible = False
Else
   Me.txtSubTotal.Visible = True
End If