>>>Hi,
>>> I am displaying an address on a screen. I concatinate the address, and include the CHR(13)'s to give it lines. I do this incase AddressLine2 is blank. This also lets me get the city, ST ZIP in a nice format. The problem is that if the address lines are too long they will wrap. (ie. all 'W'). How do I cut them off at a given apearant screen length, so that they will not wrap? Thanks.
>>>
>>>Daniel
>>
>>SUBSTR(lnAddr1,1,25)
>>
>>This will only show 25 characters of the value.
>>
>>Wayne
>
>Hi Wayne,
> Yes, I have worked with SUBSTRings. This problem is more difficult. I am using a non proportional font. Because some letters are larger than average, like 'w', and some smaller, like 'i', it is imposible to know ahead of time how many characters it will take to go to the end of the screen. I want as much relavant information to show as possible. I need a way to measure the actual on screen length of a string. Not the number a characters. Thanks.
See the TXTWIDTH() function in help. That may be able to work for you.