empty fields in label printing

[johnsonk]

When printing labels there are clear lines where there is no data in an
address field. How do I print the labels without the spare clear lines?

 

[John W. Vinson]

When printing labels there are clear lines where there is no data in an
address field. How do I print the labels without the spare clear lines?

A couple of ways. On a Report you can set a textbox's "Can Grow" and "Can
Shrink" properties to Yes; so long as there is no OTHER textbox lined up to
the left or right of this one, the textbox will shrink away to nothing if it's
empty.

Or, you can construct a multiline text string by concatenating pieces in a
Query. Try the can-shrink first though and post back if it doesn't help.