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?

This one relates to the one above. I have sparse off. I now have the values available in the combo based on another field in the record. So now if a prior record contains a value that is no longer in the combo the display gets blanked out, but the controlsource still has the value.

Anyone experience this before?

Dan