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

Yes it is a numeric type... and the BoundTo combobox property is set to .T.

It seems that when using 2 fields of different values then the combo has this weird effect.