You won't be able to get the whole memo field, so you'll have to redesign the view a bit, e.g.

CREATE SQL VIEW myview AS ;
 SELECT charfield, memofield, LEFT(memofield,100) As memocombofield, etc... ;
 FROM mytable

Then change the RowSource as follows:

Combobox.RowSourceType = 6 && fields
Combobox.RowSource = "myview.charfield, memocombofield"

One nice thing about comboboxes with a RowSource pointing to a cursor - as the selected item changes in the combobox, the record pointer in the RowSource cursor moves accordingly. So if you need the actual memo field value, you can get it right from the RowSource cursor. e.g.,

** Combobox.Valid()
thisform.Edit1.Value = myview.memofield