>>>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

Okay, for the dropdown, Add the descriptive column to your record source. Just as an FYI, I don't bind controls to an alias, rather to an SQL statement, though either will work. Make sure both your descriptive column and your key column are included. Put the descriptive column first, and set the boundcolumn property of the dropdown to two, and the columncount property to 1. This will display your descriptive column but not your key value, but when you reference the value property of the combo, it will be the key value.


Regards,

Jason