lables problem - should be 30, only 9 per page

Jeff_wenz

New member
Local time
Yesterday, 22:25
Joined
Jul 26, 2007
Messages
2
Help!

I created a database that worked fine for a couple years. I was then called and was told the report that is formatted as mailing labels (formatted for Avery 5160 labels which is 3 across by 10 down) was not printing 30 labels per page. Instead it was printing 9 or sometimes 8 per page - always down the left side of the page. I deleted the labels (reports) and imported the same labels from a backup. When the report is opened the first time, 30 lables per page appear and they can be printed, BUT once that report is closed, if it is reopened, it only show (and prints) 8 or 9 labels. The database does this for all the labels. This is not specific to the query criteria or the month the labels are printed.

Thinking he had inserted extra lines into a record, I systematically deleted customers, but no avail.

I am stumped. There was no update to the program that would have made this happen. No printer/printer settings were changed. This happens at the business and also on my computer.

Database was created with Access 2002.
 
I know this sounds like stating the obvious but have you checked the following:

Page Margins
Page orientation/setup
Local settings (US/UK etc.)

It is much better (talking form experience) to just create the Avery label template again using the Label wizard though. You still have the query that drives the reoprt, make it from a fresh.

Matt.
 
fixed!

I recreated the labels from scratch and everything now works.

thanks Matt!
 

Users who are viewing this thread

Back
Top Bottom