Address Labels


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

Advertisements

E

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

Alicia said:
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
 
A

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.

Alicia said:
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
 
Ad

Advertisements

F

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

address labels 1
Address Labels 2
More Address labels 6
Help with Address labels 2
Address Label Problem 3
Address Labels in Access 2000 4
Address Labels, Thanks Fred 3
Annoying spaces on address labels 3

Top