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

See here

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 :