Limit entries to combobox
 

I have a combox box on a form, and let's say it is populated with the months
of the year. I've left it blank, so that as the user types "J a " then
January pops up.

How can I stop the user for typing in a word that isn't in the dropdown
list? Let's say they type "Decmeber" (so they spell it wrong"). Is there a
bit of quick looping code to check whether the entry is valid?

Also, there are 12 comboboxes on my form, so if there is a way to handle all
of them efficiently, even better!

Thanks in advance,

Daniel

Limit entries to combobox
 

Daniel,
Look at the .Style, .MatchEntry and .MatchRequired properties of the
combobox.

NickHK

"Daniel Bonallack" wrote in
message ...
I have a combox box on a form, and let's say it is populated with the
months
of the year. I've left it blank, so that as the user types "J a " then
January pops up.

How can I stop the user for typing in a word that isn't in the dropdown
list? Let's say they type "Decmeber" (so they spell it wrong"). Is there
a
bit of quick looping code to check whether the entry is valid?

Also, there are 12 comboboxes on my form, so if there is a way to handle
all
of them efficiently, even better!

Thanks in advance,

Daniel

Limit entries to combobox
 

Hi Nick, you've been my saviour today - thanks!


"NickHK" wrote:

Daniel,
Look at the .Style, .MatchEntry and .MatchRequired properties of the
combobox.

NickHK

"Daniel Bonallack" wrote in
message ...
I have a combox box on a form, and let's say it is populated with the
months
of the year. I've left it blank, so that as the user types "J a " then
January pops up.

How can I stop the user for typing in a word that isn't in the dropdown
list? Let's say they type "Decmeber" (so they spell it wrong"). Is there
a
bit of quick looping code to check whether the entry is valid?

Also, there are 12 comboboxes on my form, so if there is a way to handle
all
of them efficiently, even better!

Thanks in advance,

Daniel