omit blank fields in mailing labels in Access

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
 
G

Guest

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
 
D

Duane Hookom

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
 

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

Similar Threads

How omit Address line 2 in mailing labels? 5
Suppress Blank Fields 3
Mailing Labels 1
Multiple mailing labels single record 3
Create multiple mailing labels on one page 1
mailing labels in access 2000 2
Default issue -- Mailing Labels for Avery 5160 4
mailing labels 1

Top