Curiously, but I guess not surprisingly, I'm seeing that DisplayValue is numeric as well, even though what is displayed is character.


>>Having just upgraded to SP2, I now am encountering an interesting problem with a combobox.
>>
>>The combobox has:

.RowSourceType = 6
>>.RowSource = 'SolomonBins.Bin'
>>.ControlSource = 'ThisForm.cBINto'

>>
>>SolomonBins.Bin is a character field; the dropdown list shows character values.
>>
>>However, the value for this combobox is now numeric (looks like ListIndex) rather than the the character value from the list.
>>
>>I haven't made any code changes to explain this.
>>
>>What gives?
>Try
>

.RowSourceType = 6
>.RowSource = 'SolomonBins.Bin'
>.ControlSource = 'ThisForm.cBINto' 
>.Value = []
>