>>>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.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)