Protected Combo Box

How do I create a combobox in a form that will display a range of options but not allow users to type in the box? In other words, I want a dropdown menu similar to one you'd see on a typical internet form.

At the moment, the nearest I can get is to use the MatchRequired property but this still allows users to type text (albeit without letting them type something that's not in the list)

Here's what I have at the moment:

ComboBox1.List = Array("January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December")

Cheers,

Owain

I'd really appreciate it if anyone knows how to sort this as the form has to be completed today.

Thank you!!!

Hello owainl,

To prevent the user from typing in the ComboBox, set the Locked property to True. This won't affect loading it.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Now I can't select any of the options in the combo box!

I'm also having the same problem here - does anyone have any advice? Using cboLocation.Locked = True prevents anything in the drop down box from being selected.

Cheers,

Alan