DBMemo field in DBGrid 1

[lespaul]

I have a paradox table with a memo field. I want to display the contents of the memo field in a DBGrid without any additional components. How can I show this?

Thanks for any help!

Leslie

 

[hilfy]

The simple answer is, you can't. However, there is a way to show part of the memo... Create a calculated field that's 254 characters wide. In the OnCalcFields event handler for the table, put something like the following:

MyTable.FieldByName('CalcNote').AsString := substr(MyTable.FieldByName('MemoField').AsString, 1, 254);

This will display the first 254 characters of your memo.

-D

 

[lespaul]

Thanks! I'll do that tonight!

leslie

 

[VintageWine]

put the following code in the OnGetText event of the memo field:

Text:=Sender.asString;

TDBGrid displays the text property of fields. TField.Text returns "[MEMO]" for a memo field by default, as you usually see. By using the OnGetText event you can modify the behaviour of the Text property to return the value you require.

Have fun
Simon

 

[lespaul]

worked like a charm Simon! Thanks,

leslie