>>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
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]