If, by "zero", you mean the numeric value of the field in the query/table
underlying the report is "0", then you could add code to the OnFormat event
of the appropriate section.
That code would set the control's .Visible property to False when the value
in the control was 0.
If you mean "null", you could use the controls' CanGrow/CanShrink properties
to "close up" the space taken by the empty control. The first way does NOT
close up.
Good luck
Jeff Boyce
<Access MVP>
