Hi Brenda,
In this situation I would create a little UDF to give me, what I want. You can place UDF at the same directory with the report, so it would be always visible.
Take a look at txtwidth function, it seems to be handy here.
Good luck!
>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
If it's not broken, fix it until it is.
My Blog