Printing labels

Pontos

Board Regular
Joined
Mar 26, 2003
Messages
132
I'm having problems, when I'm printing labels from reports.
I'm using labels that are on A4 paper (4x14 labels).
There are no margins between labels, and when I'm going to setup the page (set margins on left, right, up, down to 0), the setup for the page does not stand.
When I'm going to print that report, the Access is resetting the page setup and labels on right and down side of the page are not comlete.

Is there any macro that overrides the Access default setting?
Or is another way to overcome this problem?

Rok
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
did you use the Label Wizard (comes up when you choose new report). You can select your label size or customize, customizing is straight forward as it is mapped out to guide you which measurements go where.
 
Upvote 0
Hi,

I'm not sure if this will work but have you tried changing the default print margins in Access? This can be found through Click Tools -> Options -> General -> Print Margins. If you change the default print settings here do they remain but more importantly, do they result in funny margins on other reports?

HTH, Andrew. :)
 
Upvote 0

Forum statistics

Threads
1,221,816
Messages
6,162,148
Members
451,746
Latest member
samwalrus

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top