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

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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?
Click to expand...


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.

--
 
Back
Top