>>>I use SQL select to create a cursor, then direct it to the recordsource of the grid.
>>>Unfortunately, the cursor contain memo field. I attemp to view the content of the memo field of the grid, when I double click on the grid's cell 'memo'. But nothing happen, something missing?
>>
>>You have to: either use editbox as a grid.column.currentcontrol or use commandbutton with some code in click() event.
>
>Are you doing ODBC with any other database? In that case make sure Fetchmemo cursor property is set to True
>
>Narendra

Jasper, try this:

SELECT PADR(memofieldname,100) AS memofieldname ... INTO ...

(change memofieldname with the original fieldname)
This will construct a character field from the memo field. The PADR function sets a constant width for the field.

Nelson