>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)"?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.