Design address labels
Design for a label that may contain three to five lines, depending on the data record.
Before reading this procedure, you should be familiar with designing a basic label report. See Design labels for more information.
A common label need is printing of address labels, yet the number
of lines required for an address can vary, depending on the complexity of the address. In many
database tables that store address data, there are several fields for storing address information,
such as addr1
, addr2
, and so on. When creating an address record,
those fields that are not needed for the new address are set to NULL.
When an address is
printed out, however, those addresses that contain empty fields (addr2
is set to
NULL, for example) can cause an issue. No blank line should appear on the label. In addition, we may
have information that we want to print after the last non-blank address line included (such as a
postal code).