>>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
>
>1. What is the recordsource in that Grid?
>2. Where you did this SELECT?
>3. If the RecordSource is TableA why no just set ControlSource of that column to be : "=LEFT(memofield,40)"?

This SQL is simplified form of my original SQL.
The recordsource of the grid is aa

Ok. Thanks. It works with
SELECT LEFT(memofield,40) as field1 FROM tableA INTO CURSOR aa