Report Help

[Paul Martin]

I have just created a report the prints to my label printer.

The report has a text box for each line of the address with printing
initiated from a button within the individual record on a form.

My question is is there a way to suppress empty text boxes in the report as
some of the records that don't have all the address fields populated look
odd spaced out by the empty records

Grateful for any help

Paul

 

[Dirk Goldgar]

In

I have just created a report the prints to my label printer.

The report has a text box for each line of the address with printing
initiated from a button within the individual record on a form.

My question is is there a way to suppress empty text boxes in the
report as some of the records that don't have all the address fields
populated look odd spaced out by the empty records

How well it works depends on how you have the text boxes laid out, but
you can set each text box's Can Shrink property to Yes. That will let
the the text box essentially disappear if it's blank and there's nothing
else on the same line with it.

If that doesn't work, you can use a single text box for the whole
address, giving it a controlsource expression that assembles the address
from the individual fields, skipping those that are blank.