If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Mailing labels - page setup ?!?
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. |
#3
|
|||
|
|||
Mailing labels - page setup ?!?
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 - |
Thread Tools | |
Display Modes | |
|
|