Supressing Detail Section of Report

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I have a report with a header section that sums a group of related records.

If the sum is zero, I need to supress the detail and display only the
header. For example:

Cat1 100
Detail1 50
Detail2 50
Cat2 0 <--- doesn't show any detail
Cat3 50
Detail1 25
Detail2 25

How can I do this in Access 2002?
 
Dave said:
I have a report with a header section that sums a group of related records.

If the sum is zero, I need to supress the detail and display only the
header. For example:

Cat1 100
Detail1 50
Detail2 50
Cat2 0 <--- doesn't show any detail
Cat3 50
Detail1 25
Detail2 25

How can I do this in Access 2002?
Click to expand...


Just use a little code in the header section's Format event
to make the detail section invisible or visible depending on
the value of the total.

Me.Section(0).Visible = (Me.totaltextbox <> 0)
 
Back
Top