Address Labels Issue

[emcclure]

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!

[bcooney]

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

[Fitch]

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.

[comment]

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

[Cazito]

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, 2009 by Guest

[comment]

Why would any of this be necessary?

[Cazito]

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

[emcclure]

Sliding doesn't work on merge fields unfortunately.

[emcclure]

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

Any other suggestions?

[emcclure]

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

[comment]

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.

[emcclure]

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!

[comment]

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

[Fitch]

Sliding doesn't work on merge fields unfortunately.

Yes it does.