How to eliminate blank lines on a report?

[dwalsh77]

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,

 

[Ofer]

Try and set the Can grow property of the field and the section where the
field is located in to Yes.

 

[Michael J. Strickland]

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,

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

--