RESOLVED: Access combobox style

Is it possible to set the style of a combobox on an access form to dropdown only?

I dont want users to be able to edit or type in the combobox...

I have tried using code to set the combobox.style to 2, but I get an error (method or data member not found).

There's also no option to change this property on the properties list.

Any ideas?!?!

Properties > Data Tab > Limit to List - Yes
Limits the list to only that which is in the list.

Also errors with Access itself if users attempt to enter something which is not in the list. Nothing you can do about that - its stupid users in that particular case ;) heheh

joking

Vince

Thanks for that.

I have enabled that option, but it doesn't stop users from being able to type stuff in the box. :(

I really just want them to "click and pick"...

I've just added some error handling around that code to bypass the error messages.

So now if the user types anything that's not in the list and hits enter, it just tells them to pick from the list.