Address Labels

[Mark]

I am using the label wizard to create Avery labels of
names and addresses I am retrieving from a query. However,
I keep getting a blank label between every good one. It
acts as though the data is too long and creating another
label (the blank one).

I have reduced the size of the data, made changes to the
column under page setup, created custom label with the
same result, and trimmed the result set in the query.

Can anyone tell me how I can fix this issue?

 

[John Vinson]

I am using the label wizard to create Avery labels of
names and addresses I am retrieving from a query. However,
I keep getting a blank label between every good one. It
acts as though the data is too long and creating another
label (the blank one).

I have reduced the size of the data, made changes to the
column under page setup, created custom label with the
same result, and trimmed the result set in the query.

Can anyone tell me how I can fix this issue?

Open the Report in design view and doublecheck the Page Setup
(determine the label size and the margins), and check the size of the
design area of the report. If it extends even a whisker too wide or
too tall for the printable area (page size minus margins) you'll get
this blank label. The Wizard sometimes puts in horizontal lines that
are a bit too long so check them particularly.