Preventing user input in combo box values

  • Thread starter Thread starter Atlas
  • Start date Start date
A

Atlas

I have two combo boxes showing data from a short value list (year & month) I
don't want users to input data with the keyboard into the combo box, but
just let the user pick a value with the mouse.
I've tried the enabled and locked properties uselessly. Is there any other
property the fits my needs??
 
With Limit To List set to 'Yes', a user can type anything they want into the
combo box; however, the user will get an error message:

The text you entered isn't an item in the list.
Select an item from the list, or enter text that matches one of the
listed items.

The user will not be allowed to go to another field until an item from the
list is selected.
 
Back
Top