Disable keystrokes in an unbound combobox ?

[Jay]

Hi -
Access 2003/WinXP: I have an unbound combobox (cboList) on a form and it
gets properly populated in VBA code.

Is there a design-time method to limit the user's interaction with the
combobox to 'mouse only' (no keystrokes) ? If not, how would you disable
keystrokes in a KeyDown event procedure?

Thanks,
Jay

 

[Albert D. Kallal]

I am not sure why you want to discourage keyboard skills....

However, you can disable all keys for the combo box with the keydown event
via:

Private Sub Combo0_KeyDown(KeyCode As Integer, Shift As Integer)

KeyCode = 0

End Sub

 

[Jay]

Thank you Albert. Your suggestion worked perfectly. Much appreciated.