This is so much easier than you think, this one of the coolest tricks in VFP, one that many people have never heard of!
Add a single field, and use something like this as the expression: "FirstName,MiddleName,LastName;Address1;Address2;Address3;Address3;ZipCode,State"
Try it, and get a very nice surprise! A comma separates the fields on each line, and a semicolon creates a new line. Empty fields are automatically removed.
>Hi all:
>
>I have a label that has multiple address lines. Some of the lines may be blank, so I checked the 'Remove line if blank' option.
>
>HOWEVER in my case it does not work, because I have a box surrounding the label, so it is never blank!
>
>How can I solve this AND how can I shrink the box accordingly?
>
>Thanks,
>
>Yossi