CREATE SQL VIEW myview AS ; SELECT charfield, memofield, LEFT(memofield,100) As memocombofield, etc... ; FROM mytableThen 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