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 thi
Compan
Nam
Numbe
Address Line
City (for instance)

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

 

[Evi]

Have a look (in Google Groups if you need to) the thread that has the
subject Blank Space in Access Reports. Tell us if this helps or if you need
any more explanation.
Evi

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

 

[Allen Browne]

Open your report in design view.
Right-click the Address line 2 control, and choose Properties.
Set the Can Shrink property to Yes.

Make sure the Can Shrink property for the Detail section is set to No.
Setting it to Yes also would cause the following data to move up, and the
labels would no longer align correctly.

The Trim() function is just for getting rid of spurious spaces.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

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

 

[Fons Ponsioen]

I address here just the line 1 and line 2 of the address
lines but this applies to others also.
A simpler way may be to use the following for the text box
for the address lines:
([Address Line 1] & Chr(13) & Chr(10)) & ([Address Line 2]
+Chr(13)+Chr(10))
This would print out the first addess line always and the
second only if there is an entry.
The "trick is that the
"string" & null returns "string
"string + Null returns Null
I found this in an earlier posting from Marsh.
Hope this helps
Fons

-----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