Finding information in a combo box

[Tess]

Hi,

On several websites using combo box, you can enter the first letter of the
word you are looking for several times until you find the right word. for
example, if I'm looking for Canada, entering "C" will get me to Cameroun.
However, if I keep entering "C", I will eventually get to Canada.

It seems that in Access, in order to get to the right word, you need to
spell it. Example: "C", than "a". If I enter "C", "C", rather than getting
me to Canada, it search for a word starting with "CC". Is it possible to have
the combo box react the same way as those on websites?

Hope this is clear...

Thanks!

Tess

 

[fredg]

Hi,

On several websites using combo box, you can enter the first letter of the
word you are looking for several times until you find the right word. for
example, if I'm looking for Canada, entering "C" will get me to Cameroun.
However, if I keep entering "C", I will eventually get to Canada.

It seems that in Access, in order to get to the right word, you need to
spell it. Example: "C", than "a". If I enter "C", "C", rather than getting
me to Canada, it search for a word starting with "CC". Is it possible to have
the combo box react the same way as those on websites?

Hope this is clear...

Thanks!

Tess

No. A combo box (set to AutoExpand) will present words in the order
spelled.
The repeated entering of just the first letter of a word to reach the
correct one you want works the way you wish it to if you use a List
Box.

The Combo method is much faster, especially if there are many words
that begin with the same first letter.

 

[Tess]

Hi fredg,

Thanks for your prompt reply. I've tried changing my combo box for a list
box and it works. However, I agree with you that combo box are nicer...
Will try the list box for a while and see if I like it...

Thanks,

Tess