>>>Hi all,
>>>
>>>I have a combobox in a grid that is populated by 2 fields fr0om a table. One field is the unique key (which will be use to fill the destination table) and the second one is the value that I want the user to see (ex.: key=1,value=Box, key=5,value=Bag...)
>>>
>>>My problem is that when the cursor gets on the cell the value disappears (it is there but it is not visible).The same happens after I select a value from the combo (it does not show). Once I leave the cell I see the value.
>>>
>>>How could I prevent this?
>>
>>First of all, you have to know that the displayed value of a combo is the first column, so what about table.value,key as controlsource and a boundcolumn=2.
>>
>
>Yes, that is exactly as it is set (that is if you mean recordsource instead of controlsource :) ):
>Boundcolumn = 2
>controlsource=destinationtable.key
>rowsource=sourcetable.value,sourcetable.key
>rowsourcetype=Fields
>
>>Now for the other row of the grid check the sparse property of the column.
>
>I tried the sparse property but the grid flickers a few times when the refresh of the grid happens.
>>
>>(hope i've understood your problem)
Is the key field a numeric type ? If yes, you need to check the BoundTo combobox property to .T.
Fred
--
FE AVP&Cie
Directeur du département Français
Armoni Informatique
Sydev Applications
MS VFP MVP