Avery Labels

[Guest]

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???

 

[Allen Browne]

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.

 

[Larry Linson]

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