Formatting mailing label report - creeping labels

[Guest]

I am trying to manually format for a label not found using the label wizard.
The specs are 105mm x 36mm; 8 rows, 2 cols; no space between labels; A4 size
paper. After much fiddling I cannot get the 8th row to print far enough down
the page. After a point, the 8th row moves to the next page. I'm using an
HP Laser 1010, which I would expect to allow for narrow bottom margin.

I've mostly fiddled with top and bottom margins, dims of the label itself
and distance between labels to cobble a solution, to no avail.

Any suggestions would be much appreciated!

-Nelson

 

[Mike Painter]

I am trying to manually format for a label not found using the label
wizard. The specs are 105mm x 36mm; 8 rows, 2 cols; no space between
labels; A4 size paper. After much fiddling I cannot get the 8th row
to print far enough down the page. After a point, the 8th row moves
to the next page. I'm using an HP Laser 1010, which I would expect
to allow for narrow bottom margin.

I've mostly fiddled with top and bottom margins, dims of the label
itself and distance between labels to cobble a solution, to no avail.

Any suggestions would be much appreciated!

-Nelson

What do you mean by "After a point, the 8th row... "
If more than two sheets run through before the problem occurs then it does
not sound like what would normally be called creeping where each page starts
a bit farther down than the next.

It sounds more like one of your lines is allowed to grow and does in an
occasional label.
Make sure can grow is False and try a slightly smaller font size.

 

[Guest]

What do you mean by "After a point, the 8th row... "
If more than two sheets run through before the problem occurs then it does
not sound like what would normally be called creeping where each page starts
a bit farther down than the next.

The problem begins on row 2 of sheet 1. Each row creeps upwards. I respond
by increasing the height of the label, but eventually I lose the 8th row
altogether and then have only 7 rows on sheet after sheet. When I decrease
the height of the individual label to the point that I can again see 8 rows,
then row 8 (and two or three rows above it) prints too high, ie. the 8th row
label prints partially on the bottom of the 7th row.

For page margins, I seem to be allowed a minimum of .165 inches on top, and
..285 inches on bottom. I can't assign a smaller number to the bottom margin.
I would like it to be .165 or thereabouts as well.

Thanks,
Nelson

 

[Mike Painter]

The problem begins on row 2 of sheet 1. Each row creeps upwards. I
respond by increasing the height of the label, but eventually I lose
the 8th row altogether and then have only 7 rows on sheet after
sheet. When I decrease the height of the individual label to the
point that I can again see 8 rows, then row 8 (and two or three rows
above it) prints too high, ie. the 8th row label prints partially on
the bottom of the 7th row.

For page margins, I seem to be allowed a minimum of .165 inches on
top, and .285 inches on bottom. I can't assign a smaller number to
the bottom margin. I would like it to be .165 or thereabouts as well.

The printer hardware sets minimums for margins.
I assume you have set both top and bottom margins to the margins on the
labels.
Have you made sure that all fields can't grow or shrink?
How do the reports look in prieview mode?
What happens when you use plain paper to print?
However, it does not sound like the kind of problem that would be caused by
Access.
If preiview and plain paper print normally try feeding the labels in a
different way if possible.
If not I'd reinstall the printer driver or try another printer.

 

[Guest]

The printer hardware sets minimums for margins.
I assume you have set both top and bottom margins to the margins on the
labels.
Have you made sure that all fields can't grow or shrink?
How do the reports look in prieview mode?
What happens when you use plain paper to print?
However, it does not sound like the kind of problem that would be caused by
Access.
If preiview and plain paper print normally try feeding the labels in a
different way if possible.
If not I'd reinstall the printer driver or try another printer.

Using a combination of your suggestions I'm making some progress! However,
I need to be able to use the Can Grow and/or Can Shrink properties for 2 of
the 6 lines on the label, otherwise a gap is usually created in the middle.
Would I not want to shrink the two optional mailing address controls to a
thin line, vertically close up the space, then set the two controls to Can
Grow?

 

[Guest]

Would I not want to shrink the two optional mailing address controls to a
thin line, vertically close up the space, then set the two controls to Can
Grow?

What I should have said was - use the Can Shrink property, and no need to
reduce the two optional controls/fields to a thin line.

Back to the issue of needing to print text at the very bottom of the page --
What I've discovered is that although I don't have a Report Footer, Access
seems to reserve space for the footer. I know this because I printed a
separate report which had a Footer, and the text did indeed print closer to
the bottom edge of the paper.

I'd really like the Detail Section, i.e. line 6 of my mailing labels to
print where Footer text would normally print. Am I out of luck on this one?

I'm increasingly resigned to using only 14 of the 16 labels on a sheet. I
could squeeze in the bottom row when I overlap the controls, but then I
couldn't make use of the Can Shrink property and am frequently left with gaps
on lines three and four.

Thanks again for your help!

 

[Mike Painter]

What I should have said was - use the Can Shrink property, and no
need to reduce the two optional controls/fields to a thin line.

That probably will not fix the problem if there are two across labels.
The report will use the soacing of the larger value.
You may just have to format the whole address in code and print it in a
single text box
Name & vbCRLF & Address etc
you can use If statements or the plus sign to determine if the line should
print.

Back to the issue of needing to print text at the very bottom of the
page -- What I've discovered is that although I don't have a Report
Footer, Access seems to reserve space for the footer. I know this
because I printed a separate report which had a Footer, and the text
did indeed print closer to the bottom edge of the paper.

Did you set the visible property for the footer to false?

 

[Guest]

Thank you for the additional suggestions. The first one I will likely
pursue. The second - Report Footer Visisble = No - will present problems
since I am using code in the Report Header to allow user to skip labels and
to duplicate labels. Apparently the Footer must be visible if the Header is
visible.

At least now I know why the label report isn't using the space at the bottom
of the page.

-Nelson