Avery Labels
in [Reports]
|
From: HayleyH on 23 Feb 2005 19:35 I have only just started using Access 2003 and can't get the Avery DL30 (or 5160) OR the Avery L7158 up on the drop down list of available labels. Have custom created the L7158 but have printer margin problems and only end up with two columns of labels, not 3. These labels are VERY common mailing address labels - does anyone know of another type (doesn't have to be Avery) that prints 30 to a page and is accessible from any garden variety stationary supplier???
From: Allen Browne on 23 Feb 2005 23:24 When you start the Label Wizard for reports, the labels you can choose from depend on the settings you choose for: - Unit of Measure - Label Type, and - Manufacturer. There is a choice for "Avery USA 5160" if you choose English, Sheet Feed, and Avery. It can be messy trying to get these set up by hand, and even the Wizard gets it wrong for some A4 sheets. If you are trying to set up by hand: 1. Measure the vertical distance from the top of the first label to the top of the last one on the sheet, and divide by the number of labels (not counting the last one which was not measured). Use this as the Height for the Detail section. 2. Measure the horizontal distance from the left edge of the left label to the left edge of the next label. Use this as the Width for the report. 3. Measure from the top of the sheet to the top of the first label, and from the left of the sheet to the left of the first label. Choose Page Setup from the File menu, and set these as the Top Margin and Left Margin respectively. Set the Right Margin and Bottom margin to as small a figure as you can. (Actual minimum depends on the printer driver.) 4. Still in Page Setup, on the Columns tab, set: - Number of Columns to the number of labels across the page. - Row Spacing to 0 - Column Spacing to 0. - Column size to Same As Detail. - Column Layout to Across Then Down. 5. Verify that these numbers fit on the page, i.e.: a) Top Margin + Bottom Margin + (Number of Labels vertically * Height of the detail section) must be less than the height of the sheet. b) Left Margin + Right Margin + (Number of labels horizontally * width of the report) must be less than the width of the sheet. 6. If you ever set the CanGrow or CanShrink property of a text box on the report, Access will set the CanGrow/CanShrink property of the section as well. You must therefore set the CanGrow and CanShrink properties of the Detail section back to No, because the labels are actually fixed height. -- 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. "HayleyH" <HayleyH(a)discussions.microsoft.com> wrote in message news:E508D187-C008-4993-ABB5-C03F7BE04D2B(a)microsoft.com... >I have only just started using Access 2003 and can't get the Avery DL30 (or > 5160) OR the Avery L7158 up on the drop down list of available labels. > Have > custom created the L7158 but have printer margin problems and only end up > with two columns of labels, not 3. These labels are VERY common mailing > address labels - does anyone know of another type (doesn't have to be > Avery) > that prints 30 to a page and is accessible from any garden variety > stationary > supplier???
From: Larry Linson on 24 Feb 2005 12:55 "HayleyH" <HayleyH(a)discussions.microsoft.com> wrote in message news:E508D187-C008-4993-ABB5-C03F7BE04D2B(a)microsoft.com... > I have only just started using Access 2003 and can't get the Avery DL30 (or > 5160) OR the Avery L7158 up on the drop down list of available labels. Have > custom created the L7158 but have printer margin problems and only end up > with two columns of labels, not 3. These labels are VERY common mailing > address labels - does anyone know of another type (doesn't have to be Avery) > that prints 30 to a page and is accessible from any garden variety stationary > supplier??? I have, recently, experienced some difficulty using the Access 2003 Label Wizard for (genuine, not clones of) Avery 5160 labels on an HP G85 multifunction device. My Access 2003 is, as best I can tell, completely up to date. The problem I had was that the first label did not start far enough from the top of the page, and each one was printed a little higher on the label -- until they went off the label. It was as though the Wizard improperly set/calculated the top margin and used a slightly too small value for label height. This was not complicated by use of non-US paper sizes, etc. -- standard US Avery 5160, on 8.5" x 11" background stock. As I was able to salvage enough labels from the page for my purpose at the time, and time was "at a premium", I have not pursued the matter. In the past, Avery supplied the Avery Label Wizard to Microsoft, so you might check at the Avery website to see if they have an updated copy. Larry Linson Microsoft Access MVP
|
Pages: 1 Prev: OpenArgs Error Next: Choose printer+parameters programatically |