General information
Category:
Forms & Form designer
>>Well, assuming you're filling the grid via a SQL statement (although it's probably possible to do it straight from the table as well), you would e.g. do the following for your memo field called yourmemo:
>>
>>SELECT id, name, ALLT(MLINE(yourmemo,1))+ALLT(MLINE(yourmemo,2)) as yournewmemo FROM yourtable etc....
>>
>>To make sure, you could include lots of lines of the memo field so you don't miss anything in the grid, but I assume that in practice this is not always needed.
>>
>>Hope this helps.
>>
>>Rene.
>
>The original idea was to make this field editable in the grid. I don't think, your idea will allow to edit content of the memo.
Not unless you create another data entry form where you can edit the field (but you may not want this). This does not only apply to this field, but could to others as well. I've done this with an application where I fill the grid using a SQL statement. When the user wants to edit a field, they double click. A simple data entry form appears where they can change the data. The data type if trapped before the form is launched so that the appropriate field type can be displayed on the form. When the data are saved, the record is located and the field value replaced in the table.
Previous
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