omitting blank fields

[Lynne]

I have a report that lists various employee benefits. If
a particular employee doesn't have a particular benefit,
my report originally printed the label for that benefit
with 0.00 in the amount field. Now they want me to change
it so that if the employee doesn't have a benefit it just
skips it altogether. I tried setting the fields and their
labels to invisible in the ON FORMAT property if the
amount is 0 but it leaves spaces. How can I get it to
print only those benefits that the employee has without
leaving big gaps in my columns?

TIA,
Lynne

 

[Marshall Barton]

I have a report that lists various employee benefits. If
a particular employee doesn't have a particular benefit,
my report originally printed the label for that benefit
with 0.00 in the amount field. Now they want me to change
it so that if the employee doesn't have a benefit it just
skips it altogether. I tried setting the fields and their
labels to invisible in the ON FORMAT property if the
amount is 0 but it leaves spaces. How can I get it to
print only those benefits that the employee has without
leaving big gaps in my columns?

To close up the space used by control that you've made
invisible, you need to set the control's (and its section's)
CanShrink property to Yes.