Originally Posted by
elhale
...so far it has seen "Central" and "central" as two different groups...
This is really weird because Access, by default, is Case Insensitive. There are a couple of things you can do to get it to recognize the difference be Upper and Lower Case, but it's something you have to explicitly instruct Access to do...not something that 'just happens.'
If the number of selections is small enough that scrolling down them to find the desired one is adequate, without using the AutoExpand feature, you can simply prevent anything from being entered, freehand, as it were, into the Combobox. The code is fairly simple:
Code:
Private Sub ComboBoxName_KeyDown(KeyCode As Integer, Shift As Integer)
Select Case KeyCode
Case vbKeyReturn, vbKeyTab, vbKeyUp, vbKeyDown
KeyCode = KeyCode 'Accept these keys
Case Else
KeyCode = 0 ‘Block all other keys
End Select
End Sub
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007