Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why blank on the first line?
Message
From
05/12/2022 10:27:43
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
01685430
Message ID:
01685432
Views:
63
Likes (1)
>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.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform