This report prints a mailing address and the letter is then stuffed into a windowed envelope. Going landscape is not an option.

Brenda


>
>In the Report Designer, can you go to File/Page Setup and change it to >landscape? If that is acceptable, the open the report table and delete the >DRIVER, DEVICE and OUTPUT lines from the EXPR field in the report.FRX table. >Then clear out the TAG and TAG2 fields.

>>
>I have a report which contains a reportfield that is appropximately 200 pixels in length and there is no room to make it any wider. My client wants to fit in four fields, subdivsn c(25), phase_unit c(4), block c(4), and lot c(8) in that order. Well of course if all the characters are non-blank, they will not all fit. But if it can not all fit they want the full lot, block, and phase_unit and trim the subdivsn.
>
>I am at a lose. I have Arial point 8, but how would I know how many of their text will fit in a 200 pixel field, and how would i trim the first field to make the rest fit. Any ideas?
>
>The current expression in the reportfield is the following but it is not working as desired.
>
>IIF(EMPTY(subdivsn),"*",ALLTRIM(subdivsn) + ' ' + IIF(EMPTY(phase_unit),"*",ALLTRIM(phase_unit)) + ' ' +
>IIF(EMPTY(block),"*",ALLTRIM(block)) + ' ' +
>IIF(EMPTY(lot),"*",ALLTRIM(lot))
>
>
>Thanks
>
>Brenda