Address Labels

[Guest]

Hi I want to have a report with address labels.
They are
Company,
Name,
Number,
Address line 1,
Address line 2,
Town,
City,
Post Code. (Set up to show like that)
However, in many cases there is not an address line 2, or town for instance. I want then for the remaining columns to move up. Like this
Company
Name
Number
Address Line 1
City (for instance).

I think it could involve the trim function? Not sure though, any better ideas? Thanks in advance

 

[BP]

The trim function would removeleading and trailing spaces
from that particular string. For address line 2, you
would use the can shrink and can grow property, set both
of them to true. Click on the textbox, properties,
format and you will see the properties.

-----Original Message-----
Hi I want to have a report with address labels.
They are
Company,
Name,
Number,
Address line 1,
Address line 2,
Town,
City,
Post Code. (Set up to show like that)
However, in many cases there is not an address line 2,

or town for instance. I want then for the remaining
columns to move up. Like this

Company
Name
Number
Address Line 1

City (for
instance).

I think it could involve the trim function? Not sure

though, any better ideas? Thanks in advance