How do I set up labels in access that have 3 - 5 lines of detail?

G

Guest

I am attempting to create labels in Access from a query. The detail of the
labels varies by label it can have up to 3 different rows of names in it.
When I attempt to create labels, they are not spaced correctly when the
labels print, because of the varying lines. Is there any way of fixing this?
 
M

Michael J. Strickland

Denise B said:
I am attempting to create labels in Access from a query. The detail of the
labels varies by label it can have up to 3 different rows of names in it.
When I attempt to create labels, they are not spaced correctly when the
labels print, because of the varying lines. Is there any way of fixing
this?


If you mean empty fields are leaving empty rows within a label, you need to
set all but the first text box on the label to:
Can Shrink = Yes.

If you are talking about the placement of labels on the page, you need to
adjust your column settings in File->Page Setup->Columns.

--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top