Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Showing memo in grid
Message
From
02/12/2008 13:14:16
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01365156
Message ID:
01365194
Views:
13
>>>Hi,
>>>
>>>I added a memo field to a grid. The grid is initialized on-the-fly based on values in a resource file. The problem I have is that only first 10 characters of the memo field are showing in the grid column. I did remove object Test1 and replaced it with EDITBOX. And the width of this column is wide enough to show the content of the memo. And I see the EditBox with a vertical scroll bar. And I know that the cursor does have the memo field with entry longer than 10 characters.
>>>
>>>What can be preventing the grid from displaying the entire content of the memo field?
>>>
>>>Thank you in advance for any suggestions.
>>
>>This thread is so big, maybe you got the answer already, but anyway:
>>The column controlsource should look following:
>>
>>Column.ControlSource="''+CHRTRAN(LEFT(table.memofield,250),CHR(13)+CHR(10),SPACE(2))"
>>
>
>You maybe right. The Column.ControlSource I have is the field name. That is, it is:
>
>
>Column.ControlSource = "MyTable.MyMemoField"
>
>
>But I will try your suggestion now. Thank you.

Your code will bomb in case of memo field longer than 255 chars.
Edward Pikman
Independent Consultant
Previous
Reply
Map
View

Click here to load this message in the networking platform