General discussion

Locked

Mailing Labels, Skipping a field.

By luciano991 ·
Ok,

I'm making mailing labels using an Access 2000 mailing label report. I include the Middle Initial field in the label. However, if a record has no data in this field, an extra space is created between the first and last name. How can I eliminate this space on the label when there is no Middle Initial. I have approached this from the Word Mail Merge tool with the same result. Access will skip a line where there is no data but can it be trained to skip a field where there is no data. Thanks

Mark

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Mailing Labels, Skipping a field.

by DKlippert In reply to Mailing Labels, Skipping ...

Try this expression using:

& IIF(Nz([MI],[MI] & " ","")

=[FirstName] & " " & IIF(Nz([MI],[MI] & " ","") & [LastName]

Collapse -

Mailing Labels, Skipping a field.

by luciano991 In reply to Mailing Labels, Skipping ...

Poster rated this answer

Collapse -

Mailing Labels, Skipping a field.

by luciano991 In reply to Mailing Labels, Skipping ...

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums