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:
00700892
Views:
12
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform