>I have a listbox containing 2 columns representing 2 fields from a table. The field belonging to the value property of the listbox is a MEMO field. When I try to retrieve the value of the listbox I get the word 'MEMO' rather than the actual content of the memo field. What am I missing?
>
>Thanks for any input.
Use an SQL rowsource. ie:
with myListbox
.RowSourceType=3
.RowSource = "Select First_Name-(' '+Last_Name) as Name,left(notes,20) as myNotes,"+;
"notes,emp_id from employee into cursor crsEmployee"
.ColumnCount = 2
.ColumnWidths = "100,300"
endwith
lcMemo = crsEmployee.notes
Cetin