How do you change bottom margin to allow full page of
names to print on standard Avery address labels of 3
columns and 10 rows? Can only get 9 names to appear and
the rows are not spaced correctly to fit the label page.
Any ideas on what to try? Thanks. Jude
Jude,
Modern printers have a minimum no print zone on all margins, left,
right, top, and bottom.
The length of the detail section for that last row of labels is just a
tad to much for your printer.
Here are some trial and error things you can do to perhaps resolve
this difficulty:
1) Make sure the bottom margin for the label report is small enough.
Set it to 0" in File + Page SetUp.
When you save the change, it will be reset to the printer minimum.
2) Slightly move the label position a bit higher on the detail
section, so the top line prints nearer the top of the label.
3) Replace all the label controls you now have with just 1 text
control, sized just a shade less than the maximum height that will fit
in the Detail space available. Place it as close to the top of the
detail section as you can, and still have the first row print on the
label.
Name this new control [CombinedAddress]
** (Change the field names below, as needed.)**
Set it's Control Source to:
= [FirstName] & " " & [LastName] & Chr(13) & Chr(10) & [Address] &
Chr(13)
& Chr(10) & [City] & ", " & [State] & " " & [Zip]
The above has the advantage of spacing each line slightly
closer than using individual text boxes.
Preview the report.
If necessary, go back to design view and make the label height
progressively smaller, (from the bottom) until you get that last label
row to show.
4) Make the Font size smaller so that you can make the above text
control height smaller.
5) It may not be possible to print all the rows of labels.
