>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
Hi Antonio,

You need to put an editbox in the grid and use that to show the contents of the memo field, in place of the textbox.

HTH
Beth