General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only