Print Avery Labels 4 Up on One Page

[GeyikBaba]

In Access 2003 I have a project to print Avery 5168 labels (3 1/2 x5) 4 up
on a page in landscape.

They will be printed on a laser printer.

Each label will be different in that it will print the data from one record
in the source recordset.

Could someone point me in the right direction on beginning this project? It
seems like I somehow have to make a page within a page, or 4 3 1/2 X 5 pages
contained in one page. Is this a case where a subreport would be used?

Many thanks
Mike Thomas

 

[Guest]

This may help:

http://office.microsoft.com/en-us/access/HP051874161033.aspx?pid=CH063650521033

 

[Roger Carlson]

There is a Label Wizard in the New Report section that will allow you to
create labels. Avery 5168 is one of the choices, so it will do it for you.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[OnlineLabels]

I recommend that you check out product OL5100WX at the link below. It
lays out the same as Avery 5168 and is significantly less expensive.

http://www.onlinelabels.com/ol5100.htm

Dave Carmany
OnlineLabels.com

 

[GeyikBaba]

Many thanks Roger, I do not have the Avery 5168 in the wizard, I suppose I
coulg get it in an udate, but your advice did point we to the custom label
wizard which solved the problem for me.

Mike Thomas

 

[GeyikBaba]

Many thanks, that did the trick.

Mike Thomas

This may help:

http://office.microsoft.com/en-us/access/HP051874161033.aspx?pid=CH063650521033