Access Mailing Labels 1

[AndyHorn]

I have created a Mailing Labels report in Access 2000 using the Labels Wizard, selecting the Avery Label L7161 template and sheet, not continuous labels and no matter what I do it doesn't use the last row of labels on any of the pages.

This is really annoying and a waste of labels.

Anyone got any ideas of why it does this and how to get it to use all of the labels on a sheet?

Thanks

 

[67peshawar294]

Andy,
You might try increasing the size of the report to 81/2x14. The printer detects the end of a 81/2x11 and stops printing before the end of the sheet. The only problem is, more often than not, the last few cm of the labels can be unreadable or smugged due to the fact that the printer cannot hold on to the end of the 8 1/2x11 paper and print the last few cm.
jim

 

[dhookom]

Andy,
This is probably due to the bottom "un-printable" area of the page for your printer. You may need to add a small amount to the bottom margin and subtract the same from the top margin. You can also lower the controls in the detail section by the same amount.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[AndyHorn]

Thanks for your response guys.

I'm using A4 page size (210mm x 297mm).

I have found that if I change 'Keep Together' to NO in the Detail Section of the report and change the 'Column Layout' to Down, then Across instead of Across, then Down, it uses all of the labels. It's not ideal in this order, but it seems this is the only choice I have unless I want to waste labels.

Cheers
Andy