memo field as part of a combobox listitem

[sncheong]

help!
the pems of my combobox are:-
style=0 dropdown combo
rowsourcetype=3
rowsource=select id,city,rate,comments from table1 where city='abc' into curs temp. [comments is a memo field.]
columnwidth=50,150,100,0

when i select the listitems, comments contains only the word "Memo". i tried to use an variable cMemo to capture it via cMemo=this.list(this.listindex,4) but it also contains the word "Memo". how can i capture the actual contents of comments memo field in cMemo? ta

 

[rgbean]

One way to do this is to change the rowsource to:
rowsource=select id,city,rate,left(comments,100) from table1 where city='abc' into curs temp

Rick

 

[danceman]

take a look at the following functions that are used to get the contents from a memo field. it is the only way to display the contents.

MLINE( )
MEMLINES( )
SET MEMOWIDTH
Attitude is Everything

 

[sncheong]

tks guys
the comments memo field contains more than 5 lines and i need to capture it completely via cMemo to put it into another table behind the scene. any other suggestion please. ta

 

[DSummZZZ]

You can run a query on the table and use a grid control, or you could use a listbox in conjunction with an edit box for the memo field using the table or a query.

Dave S.