How to eliminate blank lines on a report?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that is used for creating and printing labels. The report
pulls info from 1 table and lists the field info on a report - 1 record for
each label. The fields that are being displayed are for example, First Name,
Last Name, Email and Phone. Every one of the recipients have a first and last
name and phone, but not all have an email address. How would I eliniate the
blank line produced by a null value in a recipients email address so that it
doesn't make my label look like it is missing something. I thought it was can
shrink or something like that, but it doesn't seem to work.

Thanks,
 
Try and set the Can grow property of the field and the section where the
field is located in to Yes.
 
dwalsh77 said:
I have a report that is used for creating and printing labels. The report
pulls info from 1 table and lists the field info on a report - 1 record
for
each label. The fields that are being displayed are for example, First
Name,
Last Name, Email and Phone. Every one of the recipients have a first and
last
name and phone, but not all have an email address. How would I eliniate
the
blank line produced by a null value in a recipients email address so that
it
doesn't make my label look like it is missing something. I thought it was
can
shrink or something like that, but it doesn't seem to work.

Thanks,
Click to expand...


For the Detail section of the label, set:
Can Grow = No
Can Shrink = No

For the top line (text box), set:
Can Grow = No
Can Shrink = No

For all but the top line (text box), set:
Can Grow = No
Can Shrink = Yes

--
 
Back
Top