does the printer matter in the report design

[Guest]

Just printed mailing labels for the first time on a printer I had to buy two
months ago to replace the previous printer. The labels came out 9 by 3
instead of 10 by 3. Not missing anything, the tenth row went to the first
row of the next page. Print preview shows 9 rows also.

Is there an easy way to edit this? And will I have to do this edit for all
of my mailing label reports? About 17 different reports.

 

[Guest]

Just to follow up: I just realized I printed the wrong report, by only thee
weeks. The report I really want is also using only 9 rows of the 10 row
sheet.

 

[fredg]

Just printed mailing labels for the first time on a printer I had to buy two
months ago to replace the previous printer. The labels came out 9 by 3
instead of 10 by 3. Not missing anything, the tenth row went to the first
row of the next page. Print preview shows 9 rows also.

Is there an easy way to edit this? And will I have to do this edit for all
of my mailing label reports? About 17 different reports.

Many modern printers have a minimum no print zone on all margins,
left, right, top, and bottom. It would appear your new printer has
different no print settings than the previous one.

The length of the detail section for that last row of labels is just a
tad to much for your printer.

Here are some trial and error things you can do to perhaps resolve
this difficulty:

1) Make sure the bottom margin for the label report is small enough.
Set it to 0" in File + Page SetUp.
When you save the change, it will be reset to the printer minimum.

2) Slightly move the label position a bit higher on the detail
section, so the top line prints nearer the top of the label.

3) Replace all the label controls you now have with just 1 text
control, sized just a shade less than the maximum height that will fit
in the Detail space available.
Name this new control [CombinedAddress]
Set it's Control Source to:
= [FirstName] & " " & [LastName] & Chr(13) & Chr(10) & [Address] &
Chr(13) & Chr(10) & [City] & ", " & [State] & " " & [Zip]

(Change the field names above, as needed.)
The above has the advantage of spacing each line slightly
closer than using individual text boxes.
Preview the report.
If necessary, go back to design view and make the label height
smaller, (from the bottom) until you get that last label row to show.

4) Make the Font size smaller so that you can make the above text
control height smaller.

 

[Guest]

1) Make sure the bottom margin for the label report is small enough.
Set it to 0" in File + Page SetUp.
When you save the change, it will be reset to the printer minimum.

The bottom margin is .585 on the HP DJ 5440. I could not change that.

2) Slightly move the label position a bit higher on the detail
section, so the top line prints nearer the top of the label.

Tried, no change

3) Replace all the label controls you now have with just 1 text
control, sized just a shade less than the maximum height that will fit
in the Detail space available.
Name this new control [CombinedAddress]
Set it's Control Source to:
= [FirstName] & " " & [LastName] & Chr(13) & Chr(10) & [Address] &
Chr(13) & Chr(10) & [City] & ", " & [State] & " " & [Zip]

Not sure I understand where I am supposed to do this.

4) Make the Font size smaller so that you can make the above text
control height smaller.

Already at 8, can't go smaller in the properties.

Thank you for your quick response.

 

[fredg]

See comments in-line....

The bottom margin is .585 on the HP DJ 5440. I could not change that.

Well, that's more than the 0.46 on my HP. That extra 0.12 of an inch
may be the problem.

2) Slightly move the label position a bit higher on the detail
section, so the top line prints nearer the top of the label.

Tried, no change

3) Replace all the label controls you now have with just 1 text
control, sized just a shade less than the maximum height that will fit
in the Detail space available.
Name this new control [CombinedAddress]
Set it's Control Source to:
= [FirstName] & " " & [LastName] & Chr(13) & Chr(10) & [Address] &
Chr(13) & Chr(10) & [City] & ", " & [State] & " " & [Zip]

Not sure I understand where I am supposed to do this.

You do this in place of the current controls in the detail section.
Delete the 3 controls that are now in the detail section which show
the name, address, city, etc.

Add 1 unbound control from the tool box tool button.
Set it's control source to what I gave you above, substituting your
own field names.

Already at 8, can't go smaller in the properties.

Sure you can make it smaller.
Just type a 7 (or a 6, or a 5) in the font size box.

Note: You can also make it bigger than the 72 Access shows by entering
a larger value (up to 127, I think).

Thank you for your quick response.

If nothing helps, you'll just have to live with 27 labels instead of
30.

 

[Guest]

Sorry none of these worked. HP support doesn't seem to be set up to respond
to this so I will try Avery.

See comments in-line....

The bottom margin is .585 on the HP DJ 5440. I could not change that.

Well, that's more than the 0.46 on my HP. That extra 0.12 of an inch
may be the problem.

2) Slightly move the label position a bit higher on the detail
section, so the top line prints nearer the top of the label.

Tried, no change

3) Replace all the label controls you now have with just 1 text
control, sized just a shade less than the maximum height that will fit
in the Detail space available.
Name this new control [CombinedAddress]
Set it's Control Source to:
= [FirstName] & " " & [LastName] & Chr(13) & Chr(10) & [Address] &
Chr(13) & Chr(10) & [City] & ", " & [State] & " " & [Zip]

Not sure I understand where I am supposed to do this.

You do this in place of the current controls in the detail section.
Delete the 3 controls that are now in the detail section which show
the name, address, city, etc.

Add 1 unbound control from the tool box tool button.
Set it's control source to what I gave you above, substituting your
own field names.

Already at 8, can't go smaller in the properties.

Sure you can make it smaller.
Just type a 7 (or a 6, or a 5) in the font size box.

Note: You can also make it bigger than the 72 Access shows by entering
a larger value (up to 127, I think).

Thank you for your quick response.

If nothing helps, you'll just have to live with 27 labels instead of
30.