Footer in labels

[JDB]

I created mailing labels using the wizard under reports. However, I want
each label to have the same items (a line and line of text) listed at the
very bottom...essentially I want a footer on each label.

I tried putting the items in the report footer, but they only showed up at
the bottom of the label page, not each label.

I then placed them in the detail of the report (with 'can grow' and 'can
shrink' both set to NO), but the items move as the lines in the address block
flucuate.

For example, if the address block contains 6 lines, the items are correctly
placed, but if the address block is 4 lines, the items move up. They move
down if the address block exceeds 6 lines.

Any ideas? Can I create a label footer or, alternatively, lock the
position of the items?

Thanks in advance.

 

[Al Campagna]

JDB,
Since every label will have the same text, just add a Line and a Label
(with your caption) to the bottom of your label design.

Name
Address1
City, State Zip
-------------------------- (Line)
"Your label caption here" (Label)

These will appear on every label.

Be aware though that the Post Office usually balks at anything other
than a standard address label.
I once included a membership number on a client's labels (in light gray)
just above, and to the right of the Name...
Example...
J52413-113
Name
Address
CSZ

We had to remove that when the PO complained.

--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Allen Browne]

You will need to set CanGrow and CanShrink to No for the text box (and for
the section), and use a text box at the bottom of the label.

That means finding another way to get the blank lines to shrink, like this:

=([FirstName] + " " & [Surname] & Chr(13) & Chr(10)) &
([AddressLine1] + Chr(13) + Chr(10)) &
([AddressLine2] + Chr(13) + Chr(10)) &
([City] & " " & [Zip])

Note the use of + (rather than &) to suppress the CR-LF if the field is
blank.

 

[Al Campagna]

JDB,
Apologies... after reading Allen Browne's correct reply, I can see
where I missed the Can Grow/Can Shrink problem altogether.

In all the address dbs I've worked with, the only value in question (as
regfards a "legitimate" mailing address) is the second line of address
(Address2).
I've made the four text controls below Grow/Shrink =No
and... using aircode...
Name
Address1
If isnull Address2 then City State Zip else Address2
If isnull Address2 then "" else City State Zip
--------------------------------------- (line)
"Your caption here"

I think this accomplishes the same end as Allen's code, although his
version is "bulletproof"... if ANY line of address is missing.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."