Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Fields not showing all data
Message
From
25/10/1999 12:30:33
 
 
To
25/10/1999 12:21:06
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00280999
Message ID:
00281027
Views:
16
Jeff ----

Try this: In the Properties dialog for the description, change:

Expression to SUBSTR(description,15)
Check off "Stretch with overflow"
Clear anything out of Format.

You should get all 15 characters. I'm thinking that the problem lies with the amount of space you have.



>Hi Roxanne and John,
>
>I tried both the substr and left commands and get the same results as before.
>
>I am using the fields name from the table.
>
>
>>>Hi all,
>>>
>>>I have report with a description field the client wants a ton of fileds on the report so I have the description field to show only 15 char of the 30 char field. The problem is it does not show the first 15 char all the time. For some reason if a space is in the description then it will break there if the next word goes over 15 char.
>>>
>>>I have never seen this happen before but I did verify this by changeing the data.
>>>
>>>Does anyone know of a workaround for this?
>>
>>What about putting a SUBSTR() function in the field expression to pull out the 1st 15 characters?
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform