>>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.
Your suggestion was helpful in this regard: I noticed that there was an empty space before the email address, in the email address field. I removed this empty space and now everything prints correctly.
Thank you!
"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