>Dear all,
>
>Hi,
>Anyone know how to select memo field in SQL Select statement and display into combo box. What I had try the combo box it just display the value like 'memo' I can't see the detail of memo.
>
>Thank very much in advance for your reply .

You can convert memo into character field.

SELECT PADR(mymemo,254) AS something ...