Address Labels

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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,
Click to expand...
or town for instance. I want then for the remaining
columns to move up. Like this
Company
Name
Number
Address Line 1
Click to expand...
City (for
instance).
I think it could involve the trim function? Not sure
Click to expand...
though, any better ideas? Thanks in advance
 
Back
Top