>>>>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
Hi Luis,
I already replied to Dragan that the problem was a space character in front of the email address.
All set now.
Thanks.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham