Jump to content

Problem: Unwanted space between names in labels


Tony Martin
 Share

This topic is 5699 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hello all! I have an issue that has perplexed me for years, and now it's time to see if I can't get it worked out.

The problem is unwanted blank space in line 2 of my (auto-generated) Avery 5160 label layout when there is no person #2 in that <<>> field.

For instance - the lauout looks like this:

<> <>

<> <>

<> <>

<> <> <>

When "<>" and "<>" do not have any values in them, there is a blank line there.

How do I get rid of that blank line? Sliding/Printing does not seem to work becuase it only appears to handle "box-type" fields, not these "<<>>" fields.

Any and all suggestions would be appreciated, and will be rewarded with a cyber-box of old Valentine's Day chocolates! :(

Tony in Vegas

Link to comment
Share on other sites

OK, as it turns out, here's the calculation I churned out based on the information presented above (using my field values) - I hope this helps anyone else out there:

CALCULATION FIELD - TEXT RESULT - NO SLIDING/PRINTING SELECTED

M1_MA_NAME1F & " " & M1_MA_NAME1L & ¶ &

If ( not IsEmpty ( M2_MA_NAME2F ) and ( not IsEmpty ( M2_MA_NAME2L )) ; M2_MA_NAME2F & " " & M2_MA_NAME2L & ¶ ) &

If ( not IsEmpty ( M2_MA_NAME2F ) and ( IsEmpty ( M2_MA_NAME2L )) ; M2_MA_NAME2F & ¶ ) &

If ( not IsEmpty ( M3_MA_ADDY1 ) ; M3_MA_ADDY1 ) & If ( not IsEmpty ( M4_MA_ADDY2 ) ; " " ) &

If ( not IsEmpty ( M4_MA_ADDY2 ) ; M4_MA_ADDY2 & ¶ ; ¶ ) &

If ( not IsEmpty ( M5_MA_CITY ) ; M5_MA_CITY ) & If ( not IsEmpty ( M5_MA_CITY ) ; " " ) &

If ( not IsEmpty ( M6_MA_ST ) ; M6_MA_ST ) & If ( not IsEmpty ( M6_MA_ST ) ; " " ) &

If ( not IsEmpty ( M7_MA_ZIP ) ; M7_MA_ZIP )

:( Tony in Vegas :

Link to comment
Share on other sites

This topic is 5699 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.