Blank Pages When Printing Labels

[Stonewall]

I have setup some labels to print and no matter what I do, a blank label
prints between each label. (Access 2003)

Each time I go to print I get the message I am grown to hate: The section
width is greater than the page width. I don't understand how there can be
more data than can fit on the label with the settings I am using. Even if
I take off the two fields I have on the label I still get a blank record with
no data to print. Someone please help me, if you can.

Here are my settings: PAGE SETUP: Label width 3.25, Height 1", number of
columns 1, margins are the lowest it will allow me to enter, 0.4 top, 0.6
bottom, 0.23 left and 0.6 right. In design view I have made the label
footprint actually smaller to ensure it would all fit on one label, 2.75
wide and .75 high. The font is Arial 12. I removed the header/footer and
selected Print Data Only.

 

[JamesDeckert]

In design view, check the width of the report and make sure it is small
enough with your margin settings to fit on the page. If it is too large
you'll get a blank page after every printed page. (I can't tell if that is
your symptom from your description)

If your symptom is a blank label after each printed label, try just putting
one field on the label which is smaller that your label, then add fields
until the problem occurs. Maybe you can deduce something from this.

James

 

[Chuck]

I have setup some labels to print and no matter what I do, a blank label
prints between each label. (Access 2003)

Each time I go to print I get the message I am grown to hate: The section
width is greater than the page width. I don't understand how there can be
more data than can fit on the label with the settings I am using. Even if
I take off the two fields I have on the label I still get a blank record with
no data to print. Someone please help me, if you can.

Here are my settings: PAGE SETUP: Label width 3.25, Height 1", number of
columns 1, margins are the lowest it will allow me to enter, 0.4 top, 0.6
bottom, 0.23 left and 0.6 right. In design view I have made the label
footprint actually smaller to ensure it would all fit on one label, 2.75
wide and .75 high. The font is Arial 12. I removed the header/footer and
selected Print Data Only.

Open your report in design mode. Make sure the detail section width and height
are the same as the label width and heigth

Chuck
--