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
|
|||
|
|||
Avery Labels
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??? |
#2
|
|||
|
|||
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" wrote in message ... 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??? |
#3
|
|||
|
|||
"HayleyH" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
labels - Avery 5166 | [email protected] | General Discussion | 1 | January 5th, 2005 04:19 PM |
Why can't I use Mail Merge Wizard with Avery 2160 labels?. | Andy39 | Mailmerge | 1 | December 10th, 2004 02:19 AM |
avery 5418 labels do not show up in list | Shawn | General Discussion | 1 | November 12th, 2004 03:24 AM |
Avery 5395 Name Labels | W. Guy Delaney | Page Layout | 1 | May 8th, 2004 04:04 AM |