Preventing user input in combo box values

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??
 
C

Cheryl Fischer

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo or list box 0
Combo box 0
COMBO BOX vs Uppercase 6
Locking a combo box 5
Address selection on combo box help 2
Combo Box On Click 8
Combo Box Formatting 1
How to switch combo boxes? 1

Top