I'm sure plenty of you have encountered this problem: Mailing Labels. The DB I'm working on needs the ability to print mailing labels. We're using Avery 5160 Labels and a HP DeskJet 600C Printer. I used the wizard under Access XP to create the labels, but due to the sophistication of the database, the wizard only setup the form and some other simple things. Now that I've got the form's and queries and mountains of VBA out of the way, I've noticed that Access won't let me set the margins on the report as I need them.
Left and right margins cannot be less then 1/4"!? Is this because of the HP printer, maybe a laserjet would let me get 1/8"? Also, the top margin 1/2" is fine, but the bottom will only allow .573", not 1/2". What gives? Can I override these settings anywhere, or should we look at other labels with bigger margins? Someone please help.. Thanks.
Left and right margins cannot be less then 1/4"!? Is this because of the HP printer, maybe a laserjet would let me get 1/8"? Also, the top margin 1/2" is fine, but the bottom will only allow .573", not 1/2". What gives? Can I override these settings anywhere, or should we look at other labels with bigger margins? Someone please help.. Thanks.
