Using VFP8. I have a combobox with SQL statement rowsource. it is select col1, col2 ..

I want the combobox to show col2 when it is closed but to show col1,col2 when it is oppened (dropped) in that order.
It only shows col1 when it is closed. I thought the setting the DisplayValue will fix this problem but I can not even set the DisplayValue.

So, is there a way to show col2 when the combobox is closed and show col1, col2 when it is open???

Thanks
Mo