E
Eric
If filtering at the query level as suggestted in the
previous reply doesn't work for you, set up each textbox
on the detail line to be something like this:
=IIf([Answer]<=0,"",[FieldToShow])
Set CanShrink = Yes for both the textbox and detail
level. If you have labels on the line as well, you'll
need to change them to textboxes like this:
=IIf([Answer]<=0,"","LabelToShow")
With this approach, everything on the detail line should
be blank if the answer is <= 0. All of the textboxes
will shrink to nothing along with the entire detail level
and effectively make the line disappear from your
report. HTH....Eric
previous reply doesn't work for you, set up each textbox
on the detail line to be something like this:
=IIf([Answer]<=0,"",[FieldToShow])
Set CanShrink = Yes for both the textbox and detail
level. If you have labels on the line as well, you'll
need to change them to textboxes like this:
=IIf([Answer]<=0,"","LabelToShow")
With this approach, everything on the detail line should
be blank if the answer is <= 0. All of the textboxes
will shrink to nothing along with the entire detail level
and effectively make the line disappear from your
report. HTH....Eric