Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Printing Avery Labels - Not aligning properly 1

Status
Not open for further replies.

ssmith147

Programmer
Sep 18, 2008
2
I am using VB2008 and the embedded Crystal Reports. I am trying to print address labels in Avery 5160 and 8160 formats.

When I try to print an Avery 5160 label (or 8160 which uses the same template) the first line of the print is exactly one line too high on the printer. As a result, the first line of the address appears on the label above with the last two lines of that address. After looking closely at two different programs I have written I am seeing the same thing with reports from either database/program.

As far as I can tell there is no way to manipulate the print alignment in the program because CR uses the windows pritn driver for the printer I'm using. Although I know that some printers will allow the end user to compensate for this not everyone will have the option (for example- I don't! :) ).

I have had limited success with adjusting the first line of the address template (dropping it down about 1/8") which aligns the labels, but causes the right-hand column to disappear and move tot he next sheet, which means I'm wasting 10 labels per sheet.

Is there a way to change this?
 
I have had trouble with this, and for labels 5160 or 5260, have had to change both the margins set in file->page setup to:

top: .75
left: .25
bottom: .25
right: .33

...and the width to 2.5, height to 1.0, and gap to .2 in the section expert->detail->format with multiple columns->layout tab.

This change worked for me and for many people with different printers using my label reports.

-LB
 
Hi, lbass,

Thanks for the input, I really appreciate it. I was starting to play with those settings myself and I got a workable solution, but I was very concerned about how it would appear on someone else's printer. Since you've tested these settings in multiple situations, I'm going to go with them.

Thanks again.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top