If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
omit blank fields in mailing labels in Access
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 |
#2
|
|||
|
|||
omit blank fields in mailing labels in Access
Set the text box's Can Shrink property to Yes.
-- Duane Hookom MS Access MVP -- "Tigger2405" wrote in message ... 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 |
#3
|
|||
|
|||
omit blank fields in mailing labels in Access
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 "Tigger2405" wrote: 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 |
#4
|
|||
|
|||
omit blank fields in mailing labels in Access
Hi there, thanks for your help but I checked and it already was. Regards
"Duane Hookom" wrote: Set the text box's Can Shrink property to Yes. -- Duane Hookom MS Access MVP -- "Tigger2405" wrote in message ... 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 |
#5
|
|||
|
|||
omit blank fields in mailing labels in Access
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 -- Duane Hookom MS Access MVP -- "Tigger2405" wrote in message ... Hi there, thanks for your help but I checked and it already was. Regards "Duane Hookom" wrote: Set the text box's Can Shrink property to Yes. -- Duane Hookom MS Access MVP -- "Tigger2405" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
print mailing labels using access 2002 database | suziecom | Setting Up & Running Reports | 1 | June 18th, 2005 08:29 PM |
Why is a French Spellchecker a "required" update for English speak | French Spellcheck Required? | General Discussion | 23 | April 26th, 2005 01:17 AM |
Mailing Labels - Outlook to Word? | Charliec | Mailmerge | 2 | December 5th, 2004 05:46 PM |
is Access 2003 any better than XP? | Gorb | Using Forms | 2 | November 11th, 2004 09:20 AM |
Access XP Compared to Access 2003 | Mardene Leahu | New Users | 1 | October 1st, 2004 05:11 AM |