Can you hide a groupfooter based on criteria?

[Legends77]

Tried using:

Private Sub GroupFooter2_Print(Cancel As Integer, PrintCount As Integer)
If Me.SubGroup = "Scheduled Time" Then
Me.GroupFooter2.Visible = False
Else
Me.GroupFooter2.Visible = True
End If

End Sub

But does not work. Now, I can hide all the data in groupfooter if the criteria is met but leaves a "blank line" and I was trying to avoid that blank line.

If I exclude "Scheduled Time" in the query, the "total" formulas do not work. Unfortunate, but I need the time in the query for calculations but don't want it to show in the report.

 

[MajP]

You may be able to use the can grow/can shrink property of the section and the controls. Shrink everything down, and if the footer controls have data it will grow to fit.

 

[Legends77]

Don't know if it is because even if hidden it still considers it having data, but dot not work. However, I have gone ahead and did if.....visible=false for all boxes in the footer in the meantime.

If anyone else has any suggestions, I am open to them. Right now the row is not visible but does cause a blank like that I would like to get rid of.

 

[dhookom]

Private Sub GroupFooter2_Print(Cancel As Integer, PrintCount As Integer)
  Cancel = (Me.SubGroup = "Scheduled Time")
End Sub

Duane
Hook'D on Access
MS Access MVP