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