I'm having a issue with creating regular US address labels. These are the fields I have and how they're formatted:

<>

<>

<>

<>, <> <>

The problem is when I preview my labels there are blank lines within them because the Address 2 field is blank. Like this:

Jane Doe

123 American Way

San Francisco, CA 94400

How can I fix this? Is there a way I can only show the field if it has data in it?

Please help!

In layout mode, select the merge fields from Address2 and below and set them to slide up.

If you're dealing with multiple text blocks (why?) or standard fields, then you would set them to slide up.

However, it appears you're already using merge fields (as in Insert>Merge Field...) in which case it should slide automatically, if the fields are all in one block of text.

I suspect there is a trailing space following the <> merge field.

1) Go to MANAGE DATABASE and create a new field called "Label" and make it a calculation field

2) On the SPECIFY CALCULATION dialog box insert the following formula:

NAME & “¶” &

Address1 & “¶” &

Case(not IsEmpty (Address2);Address2 & “¶”) &

City & “, “ & STATE & “ ” & Zip

Don’t forget to select “Text” for the calculation result.

3) Go to Layout Mode and insert the “Label” field as a merge field instead of inserting each field (NAME, address1, etc...) individually as you did before.

This should solve the problem.

Edited March 31, 200916 yr by Guest

Why would any of this be necessary?

Just another way of solving the same problem. It worked for me.

Sliding doesn't work on merge fields unfortunately.

I tried Cazito's way with the calculation and it still resulted with spaces in my labels.

Any other suggestions?

I can't see a trailing space after the < field. But how would I get rid of it any way?

You should also make sure that the Address2 field itself is really empty (no spaces, carriage returns, tabs etc.).

If that doesn't help, post an example file.

It worked! Thanks so much for everything. I used Cazito's calculation and your trailing advice and now it works! Thanks so all the fast responses! You guys and gals are AWESOME!

Again, you don't need a calculation for this.

Sliding doesn't work on merge fields unfortunately.

Yes it does.