Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grids and Concatenated Memo Fields
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00700853
Message ID:
00700948
Views:
13
Vlad and Yuri,

Thanks for the response. You were right, the editbox I was using with the memo field had been replaced by a textbox when I concatenated the two memo fields. Putting an editbox in the column fixes the wordwrap issue.

Another issue has come up. I did put the PADR() in the concatenation, however, I have to keep the field length to less than 254, or I get an error that the string is too long. Apparently, this is returning a character string. Of course, I chose memo fields because character was too short in the first place.

I guess I will have to look for another solution.

Thanks for your help.

TFISHER

>>Hello,
>>
>>I have a table with two memo fields and a logical field. I have created a view where I have contatenated both memo fields as follows:
>>
>>ALLT(m1)+RTRIM(m2) as mtest
>>
>>I have created a form with a grid. In the grid, I display the logical field and I display the concatenated mtest field. The concatenated field does not wordwrap. It just goes off to the right in a single line until the end of the text.
>>
>>When I display a single memo field in a grid, it wordwraps automatically based on the size of the column. I can also set whether scrollbars will be visible or not. -- with the concatenated field, there is no option for scrollbars.
>>
>>Anyone have an idea what is going on here? What do I have to do to get the concatenated memo fields to wordwrap properly?
>
>
>What is the Grid.Column.Control? Is it a textbox, or Editbox?
>
>Anyway I think that the way you concatenate will not give you desired result: the length of the field here is based on the very first record (string) length and all subsequent records will trimm string for longer length. I would use something like: padr(ALLT(m1)+RTRIM(m2),200) as mtest.
Thanks,

TFISHER
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform