making a combo box uneditable

[mnb098mnb]

how do i make a combo box uneditable in VBA.

 

[dsi]

What do you mean by uneditable? Are you referring to the user typing in a value? If so, you should use a listbox rather than a combobox.

 

[mnb098mnb]

sorry! i was a bit unclear!

I'm using a CommandBarComboBox (on a command bar), can i make it uneditable..

i.e. so the user can't put text into it!

apologies again for my vagueness.

 

[jebry]

Hi!

Combo boxes have a Limit to List property which, if you set it to yes will not allow the user to put anything in the box except what is already in the list. Access will give the user an error message and will not let them out of the box unless they choose something from the list. There are a couple of other things you should know, first there is a property called Auto Expand which should be set to yes. This property will make Access search the list as the user is typing things in and will choose the first match to display. Also, there is a NotInList Event procedure which you can use to give your users your own error message if you prefer and you can also give them the chance to add to the list in that procedure if that seems advisable.

hth
Jeff Bridgham