>>>Hi all
>>>
>>>How can I display the contents of a memo field in
>>>a grid without having to click on memo to view
>>>them?
>>>
>>>Ger
>>
>>Another alternative (instead of the EditBox, suggested in the other replies) is to set the ControlSource to something like padr(MyMemo, 100).
>>
>>This will show the first 100 characters in the memo; in my system, the user sees the remainder in an EditBox outside the grid, when selecting the corresponding record.
>>
>>Hilmar.
>
>I've recently learned, that you can have (myTable.MyMemo) as a ControlSource and it would be displayed correctly (it would not allow editting). Note the parentesis.
Well, that is fascinating. Probably the parentheses would make VFP think it is an expression, not a field.
Anyhow, in the framework I use, I prefer to use padr(...), because the framework allows the user to sort on any column (creating temp indices where required).
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)