>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.