16 Labels in a Page

[S]

Hi,
I am using 89x35mm Labels.
There are 16 Labels in a Page. (This is what we get in the market)
But Access only prints on first 14 Labels leaving last 2 Labels blank.
How can I get Access to print on all 16 Labels?
Thankyou in advance.
S

 

[fredg]

Hi,
I am using 89x35mm Labels.
There are 16 Labels in a Page. (This is what we get in the market)
But Access only prints on first 14 Labels leaving last 2 Labels blank.
How can I get Access to print on all 16 Labels?
Thankyou in advance.
S

Modern printers have a minimum no print zone on all margins, left,
right, top, and bottom.

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.

5) None of the above may work so you just may have to live with
getting one row of labels less.

 

[???]

ssi pak

Hi,
I am using 89x35mm Labels.
There are 16 Labels in a Page. (This is what we get in the market)
But Access only prints on first 14 Labels leaving last 2 Labels blank.
How can I get Access to print on all 16 Labels?
Thankyou in advance.
S

Modern printers have a minimum no print zone on all margins, left,
right, top, and bottom.

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.

5) None of the above may work so you just may have to live with
getting one row of labels less.

 

[S]

Hi,
I am using 89x35mm Labels.
There are 16 Labels in a Page. (This is what we get in the market)
But Access only prints on first 14 Labels leaving last 2 Labels blank.
How can I get Access to print on all 16 Labels?
Thankyou in advance.
S

Modern printers have a minimum no print zone on all margins, left,
right, top, and bottom.

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.

5) None of the above may work so you just may have to live with
getting one row of labels less.

________

Hi Fred,
All the necessary formatting is done such that the labels are printing at
correct positions.
Just to ensure your points mentioned above, I removed all text boxes from
the Label's Design View and kept only 1 Number field.
But I still get only 2 cols x 7 rows = 14 labels per page.
However I have 2 cols x 8 rows = 16 labels in a page.
Does Access has any setting which specifies 'Number Of Labels Per Page' ?
Thanx a million.
S

 

[fredg]

Hi,
I am using 89x35mm Labels.
There are 16 Labels in a Page. (This is what we get in the market)
But Access only prints on first 14 Labels leaving last 2 Labels blank.
How can I get Access to print on all 16 Labels?
Thankyou in advance.
S

Modern printers have a minimum no print zone on all margins, left,
right, top, and bottom.

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.

5) None of the above may work so you just may have to live with
getting one row of labels less.

________

Hi Fred,
All the necessary formatting is done such that the labels are printing at
correct positions.
Just to ensure your points mentioned above, I removed all text boxes from
the Label's Design View and kept only 1 Number field.
But I still get only 2 cols x 7 rows = 14 labels per page.
However I have 2 cols x 8 rows = 16 labels in a page.
Does Access has any setting which specifies 'Number Of Labels Per Page' ?
Thanx a million.
S

You mean you were trying to print labels without having used the Label
Wizard to set up the columns correctly?

Start again.
On the main database folder, click on Reports + New.
When the new report dialog opens select the Label Wizard.
Follow with the instructions.
Your detail section should show just one label.

By the way, you can set the number of columns in the detail section by
File + Page Setup + Columns.