>>>Hi,
>>>
>>>I have a VFP 9 report. One of the columns is email address. The width of the column is not enough for some, very long, email addressed.
>>>The column is set, in the VFP 9 Report designer as [x] Stretch with overflow. The format is Character and [x] Overlay and [x] Left are checked.
>>>What happens is that if the email address is longer than the column width allows, the first/top line is blank. Then the email address appears, on two line (as it should be). Here is an example:
>>>(Note that the email is not aligned properly here, in UT. I just do not know how to align it correctly. In real report the email appears under the heading EMAIL ADDRESS)
>>>
>>>EMPLOYEE EMPLOYEE NAME EMAIL ADDRESS
>>>123ABC John Smith
>>> john_smith@longcompa
>>> ny.com
>>>
>>>
>>>What do I need to change for this column (Email Address) in the designer?
>>>
>>>TIA
>>>
>>>Update: I just noticed that some records with a long email address do appear correctly. That is, they do not have a blank on the first line. Rather the email address is horizontally aligned with the EMPLOYEE.
>>>But some other records do look "messed up"
>>
>>Try with ltrim(email, 1, chr(13)+chr(9)+" "+chr(10)) in the email field. Just a hunch. I really suspect you have something that doesn't print but causes a new line before the actual first printable character in those addresses.
>
>I did try your suggestion but the email still prints incorrectly.
>Thank you for your suggestion.
Hi Dmitry. You could use:
ALLTRIM(CHRTRAN(email, CHR(13)+ CHR(10+ CHR(9), ''))
Luis