This article applies to a Microsoft Access database (.mdb) or a Microsoft Office Access 2007 database (.accdb), and to a Microsoft Access project (.adp).
For a Microsoft Access 2000 version of this article, see
In general, the Report Wizard assumes that it can print within .25 inch of the edge of the paper. If you find that some of the text in your labels is being cut off or is not being printed at all, try going into design mode for the report and moving text items until all of the text prints. For example, select all the controls and move the entire group down a little within the detail section to adjust for a top label being missed. You may have to make the items smaller, choose a smaller font, and move them closer together to get everything to fit without the label being cut off at either the top or the bottom of the printed page.
If your printer has such a large top margin that you cannot move your text items down far enough (or if doing so results in a visually crowded label), the next thing to do is to change the Page Setup margins so that the first label on each page is not used. To do this, click Page Setup and add the height of your labels to the top margin provided by the Report Wizard. For example, if you are using 1 inch labels, and the top margin is .03 inch, change it to 1.03 inches to skip the first label on the page. If you are having trouble with the last line of the last label getting cut off, you can use the same technique on the bottom margin to cause the last label on the page to be skipped.
Another common problem is that some labels come on sheets that are 12 inches tall, whereas the print driver only recognizes 11-inch paper. In this case, you must ignore the last label on the page and use the labels that fall within the first 11 inches.
ID do Artigo: 287661 - Última Revisão: 30 de out de 2008 - Revisão: 1