Finding information in a combo box

T

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
 
F

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
Click to expand...

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.
 
T

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
 
Top