>>I have a grid based on a view that contains a listbox that displays a value other than the controlsource. The listbox is BoundTo a surogate key that is not displayed in the listbox (columnwidth = 0). Using Sparse = .f. the screen update is too slow and looks horrible. With sparse = .t., the grid displays the surrogate key.
>>
>>How can I diplay the same value in the listboox.displayvalue when the column does not have focus?
>>
>>Thanx in advance.
>
>Dean,
>
>Could you expand on this a bit? I'm not sure I follow completely. It sounds almost like you're putting a listbox in a grid. Want to make sure I understand before I start offering advice.
>
>Regards,
>Jason

Jason, Yes, the listbox is in a grid. The situation is further complicated because the BoundColumn is a key in a related view (which is working fine). I show fields from the relation in other controls on the form. But with sparse off, my surrogate key is displayed. It means nothing to the user, and I would rather not show it to them.

thanx,
Dean