Logo

My Access Tips for Custom Microsoft Access

Application Development

by Matthew V Carmichael


Need Help?

My Tips


Links

Resources
Quick Tip Details
Question:
How can I suppress (hide) the group footer totals of my report if only one record exits in the detail section?
Answer:
Add a textbox to the group footer containing the totals.

Textbox Properties
-Name: txtGroupCount
-ControlSource =1
-RunningSum: Over Group

Then on the OnFormat add the following
Code:
If Me.txtGroupCount = 1 Then
        Me.GroupFooter1.Visible = False
Else
        Me.GroupFooter1.Visible = True
End If