In the Database window, click Reports under Objects, and then click New.ģ. Start Access, and then open the sample database Northwind.mdb or the sample project NorthwindCS.adp.Ģ. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.ġ. As a result, depending on the printer that you are using, the report may be created with a margin larger than the actual label.ĬAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. In addition, certain labels may have a left margin that is smaller than what is allowed by many printer drivers. The label dimensions for certain Avery labels were modified in Access 2002 to be the Avery standard. Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. You should not experience any loss of data when you print the labels. The message is a warning and you can safely ignore it. The total width of the report, including margins and the three-across labels, is greater than the width of the page. There is not enough horizontal space on the page for the number of columns and column spacing you specified.Ĭlick Page Setup on the File menu, click the Columns tab, and then reduce the number of columns or the size of the columns. When you use the Label Wizard to create a report, you may receive the following warning message if you are using three-across labels: This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp). Novice: Requires knowledge of the user interface on single-user computers. This article was previously published under Q290282 View products that this article applies to. Such a nuisance! - VieĬC2002: Warning in Label Wizard When You Use Three-Across Labels But is there ABSOLUTELY no way to suppress this pesky messagebox? It pops up on Preview and then AGAIN when you go to print. It seems this trouble is particular to Access 2002 and above? I copies the Microsoft Article into this msg just info-wise.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |