Limit entries to combobox

[Daniel Bonallack]

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

[NickHK]

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

NickHK

"Daniel Bonallack" <DanielBonallack@discussions.microsoft.com> wrote in
message news:03CB895B-FC11-4840-85DF-882E70B198AA@microsoft.com...
> 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
>

[Daniel Bonallack]

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" <DanielBonallack@discussions.microsoft.com> wrote in
> message news:03CB895B-FC11-4840-85DF-882E70B198AA@microsoft.com...
> > 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
> >
>
>
>