How to prevent subtotal printing if only 1 detail record

[SuzM]

If there an easy way to prevent subtotals from printing if there is only a single detail record in the group? I assume I have to add code to OnFormat??

 

[JCG4LOM]

If you're subtotalling in a footer, you might be able to do a detail count. Then you can set all your subtotal fields to

=Iif ([txtDetailCount] > 1, [txtSubTotal], "&quot

Hope that helps!

 

[dhookom]

I assume you don't want to print the entire group footer section. If this is the case, you can add a text box that counts the number of records in the group (txtDetailCount) and then add code to the On Format event of the group footer.

Private Sub GroupFooter0_Format(Cancel As Integer, FormatCount As Integer)
    Cancel = Me.txtDetailCount = 1
End Sub

Duane
MS Access MVP