Label Wizard in Access

[Guest]

How do I get the Label Wizard to accept four lines in a Avery 5160 address
label? This should be a no-brainer but with the newer Access, I have to
redesign the label every time.

 

[Guest]

Hi. I just tried it in Xp and it worked just fine, however, you may have
adjusted the font or the font size and for instance when I use times New
Roman at 6 I could get upto 6 lines, at 8 points I could get 4 lines with no
problem.
Now, this is during the wizard design. Actually once the label is designed
you can go and modify the design in the regular design mode and you can place
the text boxes closer or even slightly overlap. An other possible solution
is to create just one textbox and place the soource as (for instance)
=[LNAME] & Chr(10)& [Address]
This places the lines slightly closer together as compared to placing
several text boxes.
Hope this helps.
Fons