omit blank fields in mailing labels in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Please can anyone tell me how to prevent including any blank fields for
mailing labels. As some addresses are longer than others, I included fields
to accomodate this, but when previewing labels created from label Wizard, the
ones with shorter addresses have unsightly blank lines in the middle. Can
anyone help please? I'm using older version of Acces 97 if this helps
 
Hi there, thanks for your help, but I checked this and it was already set to
"Yes" I'm sure there's a way of doing this though, i think we covered it at
college, but was while ago. can anyone else help please?Regards
 
If you had already set the Can Shrink property to Yes, then I can only
assume
-the control source is not null or
-there are controls to the left or right of the Can Shrink text box
 
Back
Top