I would like to show memo field in textbox object. I have tried this
SELECT SUBSTR(memofield,1,40) as field1 FROM tableA INTO CURSOR aa

Thisform.mygrid.Column1.text1.ControlSource = 'aa.field1'

The problem is the content of Column1 is showed as Memo, not as SUBSTR of memo field