~Phil~
May 20th, 2004, 10:40 AM
Does anyone know how to find the length of a display field?
I have a formula that shows a database field, if the length of the returned text is greater than the viewable area of the field then I want to trim the string and make the tool tip the full return field, I can do this with
if len({SP_RPT_strCompDate;1.word}) >16 then
Mid ({SP_RPT_strCompDate;1.word},1 ,16)
else
{SP_RPT_strCompDate;1.word}
and the tool tip formula is straight forward also, but I want to replace '16' with a better way.
I have a formula that shows a database field, if the length of the returned text is greater than the viewable area of the field then I want to trim the string and make the tool tip the full return field, I can do this with
if len({SP_RPT_strCompDate;1.word}) >16 then
Mid ({SP_RPT_strCompDate;1.word},1 ,16)
else
{SP_RPT_strCompDate;1.word}
and the tool tip formula is straight forward also, but I want to replace '16' with a better way.