Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Outputting as much data in a field as possible
Message
From
04/01/1999 14:59:30
 
 
To
04/01/1999 14:57:11
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00172533
Message ID:
00172534
Views:
25
>How do I configure a text box in a report to output as much data as will fit into the field?
>
>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).
>
>
>Bob

You may use LEFT(MyField,26) as report field expression.
Edward Pikman
Independent Consultant
Previous
Reply
Map
View

Click here to load this message in the networking platform