Blank spaces prevent sliding up

[ejbSF]

Hi, all,

Could someone point me to a solution - if there is one - as to how to get FMPro (I have version 5) to slide up when there's a blank space in the line? Example:

<<firstname1>> <<lastname1>>

<<firstname2>> <<lastname2>>

<<address>> etc

If there is no "name 2", I want <<address>> to slide up, eliminating the "name2" entry. However, it seems that the space between <<firstname2>> and <<lastname2>> prevents that sliding. However yet again, if I don't include the space, when there is a "name2", I get "MarySmith" instead of "Mary Smith".

Is there a workaround?

Thanks!

Ed

[cjaeger]

place a calc field lastname_display= if(lastname;" " &lastname;"") instead of field <<lastname>>

[Vaughan]

The problem is the carriage return between lastname1 and firstname2. The solution is to make a calculation field that builds the whole text block....

Firstname1 & " " & lastname 1 &

If(IsEmpty(lastname2), "",

"

[ejbSF]

Thanks for the posts, guys. I adapted the first one (had to use commas instead of semicolons as follows: if(lastname2 <> "", firstname2 & " " & lastname2).

That worked fine, and I re-edited the other fields the same way.

Again, thanks much for your help.

Ed