Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Outputting as much data in a field as possible
Message
 
To
04/01/1999 14:57:11
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00172533
Message ID:
00172536
Views:
25
Hi Bob,

>My problem is that reports seem to truncate at a word-level. If my data is "ABC DEFGHIJKLMNOPQRSTUVWXYZ", and my field is 26 chars wide, the report will output "ABC". If I set the "Stretch" option, then all the data will display, but on 2 lines. I want the output to be "ABC DEFGHIJKLMNOPQRSTUVWXY" (all on 1 line - note that I'm accepting that the "Z" will be lost).

with a monospaced font you can use LEFT(Field,26) as Edward suggested. If you use a proportional font you don't know the length in advance. Then you can make the field horizontally much longer than needed and cover the unnecessary part of it with a white shape. This will prevent VFP from wrapping the field into the next line.

Christof
--
Christof
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform