Sizing Reports in Access 2007

ryancasey used Ask the Experts™
I am trying to figure out how to input a custom paper size in Microsoft Access 2007. The software has a lot of pre-defined sizes built in, but I can't seem to make it work with my Dymo Shipping Labels (4 x 2 1/8) Any ideas?
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Hi Ryan

You shouldn't need to specify the paper size at all.  Just ensure that Detail.Height+TopMargin+BottomMargin<= HeightOfLabel and Report.Width+LeftMargin+RightMargin<=WidthOfLabel.
Graham Mandeno - Access MVP


Thanks for the help! My biggest issue was that I didn't have the SP2 for Access installed so every time I specified a "non standard" size, it reverted to letter size.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial