labels

[briandis14]

Hi everybody. I'm running a report from
a table, and I'm using the label wizard.
The label settings are Avery 5160 / sheet feed.

My question: The print preview shows 30 labels to a page (3 across, 10 down), yet when I print I'm getting some pages
with 30 and some with 27 (skipping the
last row of labels on the page). The
labels continue on the next page, and none
of the records are misssed. What I'm wondering is why it would skip that last
row? I've checked, and there is no
pattern to when this row is skippped, it
seems to be fairly random.

Has anyone else run into this problem?

 

[cinnamoncw]

You may want to try adjusting the bottom margin. That's the only thing I can think of, I've never seen that before...

 

[briandis14]

Cinnamoncw,

Thanks for the reply but, I've tried adjusting margins and haven't come up with any fix for the problem. That's what seems to me so strange about it. It's not margins, and there is definitely no pattern to when that column gets skipped.
???

Thanks anyway,
Brian

 

[Axis]

It's possible that you have the CanGrow Property set to Yes for one or more fields, and that there will be random records where, for example, an address field takes up more than one line. That will push all of the following rows down one and may drive the final row onto the next page.

Check somewhere on the pages that this is occuring to see if some fields are taking up more than one line. You can adjust for this by setting CanGrow to No or by limiting the length of the fields used to the number of characters in your label space (this will vary according to which font you're using).