Mailing labels - page setup ?!?

I'm trying to set up a report for 5162 mailing labels. I got the specs of
4x1.333" label with .845" top and bottom margins and .1563" right and left
margins.
This results in a 11.021 page length which skips to new page before printing
bottom row of labels. Has anyone done this?
Also, I cannot get Page Setup to retain any settings. In fact, each time I
do File--Page Setup, the values change slightly even when I change nothing
else. For instance I see flip-flopping between .841, .842 and .843 for the
top margins.

So, the Label Wizard gets the answers wrong.

Reduce the bottom margin (and the top margin if necessary) so it all fits on
your 11" page.

Internally, Access stores these heights in twips, where 1440 twips = 1 inch.
The last couple of digits can change when you convert thousandths of an inch
to twips. If you prefer, you can set the number programmatically.

Also, if you specify a margin smaller than the unprintable area of your
printer, Access will increase it.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"mscertified" wrote in message
...
I'm trying to set up a report for 5162 mailing labels. I got the specs of
4x1.333" label with .845" top and bottom margins and .1563" right and left
margins.
This results in a 11.021 page length which skips to new page before
printing
bottom row of labels. Has anyone done this?
Also, I cannot get Page Setup to retain any settings. In fact, each time I
do File--Page Setup, the values change slightly even when I change nothing
else. For instance I see flip-flopping between .841, .842 and .843 for the
top margins.

Have you tried printing on Avery 5162 to confirm that they work? We
have a product that lays out exactly the same as the Avery 5162. It is
our item OL100WX. I am happy to provide you with some samples at no
charge for testing. You can check out our OL100WX at a href="http://
www.onlinelabels.com/products/ol100wx.htm"http://www.onlinelabels.com/products/ol100wx.htm/a.

Dave Carmany
OnlineLabels.com
a href="http://www.onlinelabels.com"http://www.onlinelabels.com/a

On Aug 9, 8:40 pm, "Allen Browne" wrote:
So, the Label Wizard gets the answers wrong.

Reduce the bottom margin (and the top margin if necessary) so it all fits on
your 11" page.

Internally, Access stores these heights in twips, where 1440 twips = 1 inch.
The last couple of digits can change when you convert thousandths of an inch
to twips. If you prefer, you can set the number programmatically.

Also, if you specify a margin smaller than the unprintable area of your
printer, Access will increase it.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"mscertified" wrote in message

...



I'm trying to set up a report for 5162 mailinglabels. I got the specs of
4x1.333" label with .845" top and bottom margins and .1563" right and left
margins.
This results in a 11.021 page length which skips to new page before
printing
bottom row oflabels. Has anyone done this?
Also, I cannot get Page Setup to retain any settings. In fact, each time I
do File--Page Setup, the values change slightly even when I change nothing
else. For instance I see flip-flopping between .841, .842 and .843 for the
top margins.- Hide quoted text -

- Show quoted text -