Suppresssing Fields in Reports if zero

  • Thread starter Thread starter ajs
  • Start date Start date
A

ajs

How can I suppress i.e. not display / print certain text or controls in a
report if the control is zero.
 
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>
 
Back
Top