>>>Hi all,
>>>
>>>can somebody give me a clue how to set the text> for a combobox programitcally?
>>>
>>>I have the following situation
>>>- A combobox bount to a sql statement (RowSourceType= 3)
>>>- Valid data in sql's result
>>>
>>>I like to set the combobox to a value
not in the sql result
>>>
combo.value='somevalue'
sets the value to the literal, but it's not on display and .TEXT holds the empty string.
>>>If I enter the value with the keyboard .TEXT gives me the value I've entered and value stucks wher it was (this one I can deal with).
>>>
>>>How canm I get the text in the combo?
>>>
>>>Agnes
>>
>>Hi Agnes,
>>
>>Would
>>
>>Combo.Style = 0
>>
>>help ?
>
>Gregory,
>
>no, it's the current value. I can enter via keyboard - no problem at this. I can't via programm.
>
>Agnes
Ok, then
with m.this.Parent.Combo
store 'QQQ' to .Value, .DisplayValue
? .value, .text
endwith
Gregory