Access label report produces the wrong number of labels

[Guest]

I'm running a simple report using the Avery 5160 label template to create
mailing labels for a club. The query and report are correct, but when I run
the report at home I get nine rows of 3 labels (9x 3) when it should be 10 x
3.

When I run it at work, same identical database, I get 10 x 3 as I should.

I was originally on Access 2000 at home and I thought that might be the
problem, but yesterday I upgraded to Office 2003 and the report is *still*
wrong, only 9 x 3 labels!

I haven't been too clear - home and work are now both Office 2003. I created
the report with Access 2000 at home, but when I take the database to work and
run it under Access 2003 it prints 10 x 3 labels, exactly correct. But even
after upgrading my machine at home it runs incorrectly.

Thanks in advance; I hope someone has an idea what could be wrong.

-Ken

 

[fredg]

I'm running a simple report using the Avery 5160 label template to create
mailing labels for a club. The query and report are correct, but when I run
the report at home I get nine rows of 3 labels (9x 3) when it should be 10 x
3.

When I run it at work, same identical database, I get 10 x 3 as I should.

I was originally on Access 2000 at home and I thought that might be the
problem, but yesterday I upgraded to Office 2003 and the report is *still*
wrong, only 9 x 3 labels!

I haven't been too clear - home and work are now both Office 2003. I created
the report with Access 2000 at home, but when I take the database to work and
run it under Access 2003 it prints 10 x 3 labels, exactly correct. But even
after upgrading my machine at home it runs incorrectly.

Thanks in advance; I hope someone has an idea what could be wrong.

-Ken

Different printers have different bottom margin no-print areas.

In all probability, your home printer cannot print as low as your
office printer.

1) Check the Bottom Margin settings on your report.
File + Page Setup + Margins.
Reset it to 0.
When you exit, Access will reset it to whatever your printer minimum
is. Print out a sheet (on plain paper). If it now prints 10 rows,
you're done.
If not....

2) Make the detail section SLIGHTLY less tall, as well as the
controls in the detail section. Also move the all label control's up
just a bit (so they will print higher on the label).
Print a sheet of labels (on a plain sheet of paper).
If you now get 10 rows, hold it up to a sheet of labels. If the
printing sits on the label OK you're done.
If you're still getting 9 rows, try making the section less tall
again.

3) If you've shifted the print off the labels, resize just a bit in
the opposite direction.

4) Instead of using 3 or more label controls on each label, try one.
Add an Unbound text control in place of your current label controls.
Set it's control source to concatenate the other label's data into it.
Something like:

=[FirstName] & " " & [LastName] & chr(13) & chr(10) & [Address]
& chr(13) & chr(10) & [City] & ", " & [State] & " " & [Zip]

Size this label to less than the detail section.
Run the report.
Do you get 10 rows now?
Note that the line spacing is slightly less than the usual spacing.

4) Sometimes you'll just have to lose that last row.

 

[Guest]

Hi Fred,

Thank you very much. The printer margin was, indeed, the problem and
slightly shrinking the height of the detail section fixed the problem. It
never occurred to me that margins could be the problem!

-Ken