omitting blank fields

  • Thread starter Thread starter Lynne
  • Start date Start date
L

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
 
Lynne said:
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?
Click to expand...


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.
 
Back
Top