>I have a label report that uses a 4" x 3 1/3" label.
>
>The report contains 5 fields as below:
>cLine1 is a 36 car. courier 10 line
>cLine2 is a 36 car. courier 10 line
>cLine3 is a 36 car. courier 10 line
>cLine4 is a 175 car. arial 12 line although in a lot of cases it is shorter than the 175 caracters reserved for it.
>cPersonal is a 240 car. arial 12 line although in a lot of cases it is shorter than the 240 caracters reserved for it.
>line1: cLine1;
>line2: cLine2;
>line3: cLine3;
>line4: alltrim(cLine4);
>line5: reserved for wrap of cLine4
>line6: reserved for wrap of cLine4
>line7: reserved for wrap of cLine4
>line8: reserved for wrap of cLine4
>line9: alltrim(cPersonal);
>line10: reserved for wrap of cPersonal
>line11: reserved for wrap of cPersonal
>line12: reserved for wrap of cPersonal
>line13: reserved for wrap of cPersonal
>line14: reserved for wrap of cPersonal
>line15: reserved for wrap of cPersonal
>
>I would like alltrim(cPersonal) to place itself right after alltrim(cLine4) so that if alltrim(cLine4) uses only line4 and line5, then alltrim(cPersonal) would start at line6 instead of always on line9.
>
>How do we go about doing this ?
>
>TIA
>
>Pierre Richard


There are at least two approaches you could take:
1) Use IIF() statements in your label expressions such as: IIF(EMPTY(cLine4,cPersonal,cLine4))
2) Use the Print When button on the expression form and select Remove line if blank

One of these two or a combination should yield the correct results.