Suppress footer when ony one detail line ???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a footer that prints a total for certain detail columns. I'd like to
suppress this footer when there is only one detail line. Is there an easy way
to do this ?

Thanks in advance.
 
mscertified said:
I have a footer that prints a total for certain detail columns. I'd like to
suppress this footer when there is only one detail line. Is there an easy way
to do this ?
Click to expand...


Relatively easy. Add an invisible text box named
txtDetailCnt to the detail section. Set it's control source
expression to -1 and RunningSum property to Over Group.

Now, add some code to the group footer section's Format
event procedure:

Me.Section(XX).Visible = (Me.txtDetailCnt >1)
 
Back
Top