This is by design. The drop down list for the auto-complete text items is not the same as the defined combo box for that column. If it is required that the auto-complete list be replaced with the defined combo box, the user can simply press the <F4> key when the auto-completion list is visible. If the developer would like this happen automatically, some validation will be required.
The following example has declared a global variable; intKey and initialized it to 1 in the Form_Load event:
| Private Sub ctComboMulti_KeyUp(KeyCode As Integer, Shift As Integer) |
| 'This sample will drop the combo box after the third key stroke |
| If intKey = 3 Then |
| 'The SendKeys function will send the specified keystroke to the active window |
| SendKeys "{F4}" |
| 'Once the combo box has been displayed, reset the keystrokes |
| intKey = 0 |
| Else |
| intKey = intKey + 1 |
| End If |
| End Sub |
For additional information on the SendKeys Function from the MSDN website,
click here