Thanks James. I was trying to skip this "intermediate" step (going to array) for the rowsource and simply use my view as the rowsource but I guess I can't.
>>>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
>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,
It's "my" world. You're just living in it.