Restrict Combo Box

Question

Hi,

I am having a Combo Box in my form and I want the users to select or type only the data which is defined in the drop down list.  The users should be restricted by typing their own data in the Combo Box.

I have searched it in web and I got the below code and I made it in the Key Down procedure but the same is not working for me.

Select Case KeyCode

'These keys should work even in the combo box

Case vbKeyReturn, vbKeyTab, vbKeyEscape, _

vbKeyLeft, vbKeyRight, vbKeyF1

'so do nothing here

'The rest we want to suppress

Case Else

KeyCode = 0

End Select

Please suggst.

Awaiting for your valuable reply.

Thanks in advance!

 ---

Sixthsense

Answer 1

It is not really possible to prevent the users from typing a value that does not occur in the list, but you can prevent it from being accepted: set the Limit to List property of the combo box to Yes. If the user types an invalid entry and presses Enter or Tab, Access will display an error message and refuse to accept the value.