Spacing between label rows

[Guest]

My label report puts too much space between rows of labels so they don't line up (I have created custom labels), i.e. the first couple rows of labels print fine then following rows run off the bottom of the row of labels increasingly. I page set up I have set the row spacing to 0. I have been wrestling with this for days. Thanks.

 

[Fons Ponsioen]

Hi Stephen,
I would check that the textbox heights are set to fit
(format > size to fit.
Than make sure that the size of your label is not just a
fraction too large height and width.
I would set the height to the total space from the top of
one label to the top of the next.
Make sure you do the "can grow" is set to now for all
entities invloved.
Hope this helps.
Fons

-----Original Message-----
My label report puts too much space between rows of

labels so they don't line up (I have created custom
labels), i.e. the first couple rows of labels print fine
then following rows run off the bottom of the row of
labels increasingly. I page set up I have set the row
spacing to 0. I have been wrestling with this for days.
Thanks.

 

[Guest]

Thanks, Fons. The label size was okay. I was able to fiddle with the spacing between the top of the label and the text line and that did it. However, yesterday I printed four pages of labels and when I stopped to edit some addresses in the source table and came back, the spacing was all off again. I tried to run the label wizard again but it only allows me a label with two lines... I have spent hours on this....frustrating.

----- Fons Ponsioen wrote: -----

Hi Stephen,
I would check that the textbox heights are set to fit
(format > size to fit.
Than make sure that the size of your label is not just a
fraction too large height and width.
I would set the height to the total space from the top of
one label to the top of the next.
Make sure you do the "can grow" is set to now for all
entities invloved.
Hope this helps.
Fons

-----Original Message-----
My label report puts too much space between rows of

labels so they don't line up (I have created custom
labels), i.e. the first couple rows of labels print fine
then following rows run off the bottom of the row of
labels increasingly. I page set up I have set the row
spacing to 0. I have been wrestling with this for days.
Thanks.

 

[Fons Ponsioen]

Stephen, I would check a few things,
1. Make sure you have installed the latest service packs
for the version of Access you are using.
2. Run the tools > Database Utilities > compact and
repair database.
3. Make changes to this label so it is working right and
save each time you make a change.

It sounds like you may have some defective file.
Hopefully this will help.
Fons

-----Original Message-----
Thanks, Fons. The label size was okay. I was able to

fiddle with the spacing between the top of the label and
the text line and that did it. However, yesterday I
printed four pages of labels and when I stopped to edit
some addresses in the source table and came back, the
spacing was all off again. I tried to run the label wizard
again but it only allows me a label with two lines... I
have spent hours on this....frustrating.