>>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
Antonio Carlos Kleinübing
Systems Analyst