G
Guest
How can I get Microsoft ACCESS 2003 to print 30 labels instead of 27???
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
fredg
How can I get Microsoft ACCESS 2003 to print 30 labels instead of 27???
How did you get it to print 27?
G
Guest
Using AVERY labels 8160 which has 3 across and 10 down. Will not print the
30 just 27 leaving the last row blank.
30 just 27 leaving the last row blank.
F
fredg
Using AVERY labels 8160 which has 3 across and 10 down. Will not print the
30 just 27 leaving the last row blank.
Modern printers may 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 + Margins.
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.
Name this new control [CombinedAddress]
Set it's Control Source to:
= [FirstName] & " " & [LastName] & Chr(13) & Chr(10) & [Address] &
Chr(13) & Chr(10) & [City] & ", " & [State] & " " & [Zip]
(Change the field names above, as needed.)
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 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's quite possible that none of the above will be effective, in
which case be prepared to only print 27 labels.
G
Guest
Thanks for your help!!!!
fredg said:Using AVERY labels 8160 which has 3 across and 10 down. Will not print the
30 just 27 leaving the last row blank.
Modern printers may 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 + Margins.
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.
Name this new control [CombinedAddress]
Set it's Control Source to:
= [FirstName] & " " & [LastName] & Chr(13) & Chr(10) & [Address] &
Chr(13) & Chr(10) & [City] & ", " & [State] & " " & [Zip]
(Change the field names above, as needed.)
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 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's quite possible that none of the above will be effective, in
which case be prepared to only print 27 labels.
--