>>The 2nd and 3rd columns don't show at all, or they don't show in the form you want them in?
>>
>>There is no problem assigning a memo field as a column in a combobox. It will not display "memo", but the actual memo content.
>>
>>Be sure columncount = 3 and that columnwidth for each column is adequate.
>>
>>regards,
>
>My combobox is displaying my 2nd column which is based on a memo field all as "Memo" instead of its content. My columncount is set to 4 and the RowSourceType is set to Alias. What do I need to do?

John,

My solution, and there are many others, would be to do away with rowsource = alias and use an array. Like this...

Create a new array property in your abstract combobox, aRowSource[1], and a new method, UpdateRowSource(), with the following code.

*-- myComboBox.UpdateRowSource()

WITH this

    SELECT ;
       myField1, ;
       myField2, ;
       myField3  ;
    FROM myTable ;
    INTO ARRAY .aRowSource

    .rowsource = "this.aRowSource"
    .rowsourcetype = 5 && array
ENDWITH

RETURN

Any time you need to update the rowsource, just call Updaterowsource(). If the data in your rowsource is static, as in a lookup table. Update the rowsource in the init() event of the combobox. If it is dynamic, update the rowsource in the refresh() event of the combobox.

I have never had a memo display as anything bo contents using this process.

Best of luck,