>>>>Two part question.
>>>>
>>>>I have a grid with a column that contains a combobox. The combo contains user friendly description, e.g. "14-Iowa". The value I store in the table will be the number 14. If I set the column to sparse the 14 is displayed instead of the nice description in the combobox. Anyway to get it to diplay with sparse on?
>>>
>>>I think you have to change .BoundColumn.
>>
>>Thanks Hilmar.
>>
>>My combo has two columns, "14-Iowa", and "14". The combo is .BoundTo = .t. and the bound column is 2. I don't want to store "14-Iowa" in the table. What I want to do is display "14-Iowa" when that cell does not have the focus, instead of 14.
>>
>>Dan
>
>What I usually do is set .ColumnCount = 1, but I specify two columns in the RowSource. This will make the second column invisible.
>
>BoundColumn would be this second, invisible, column. In your example, column1 would be "14-Iowa", column2, "14". The second column is saved in the current table.
>
>HTH, Hilmar.

That's basically what I'm doing. I have no probs with the combobox. It works great. When I set sparse to true on the column I want the "look" of the combo to go away and just display "14-Iowa", not the value 14.

Dan