Combo Boxes

Hi

I have created a combo box on a form which I have created. There are
approximately 500 entries (e.g. running from alpha to sierra) tied to the
combo/database. Is it possible that if the user wants to select kilo from
the combo they just type the first letter "k" and the combo navigates
automatically to the "k" options.

Also it is possible to force user to enter information in the form using
caps. Is there some sort of rule that I can create to allow for this.

Thanks

The Combobox has a Property called Auto Expand. If this is set to Yes,
it will produce the behaviour you are seeking.

If all the items in the combobox's Row Source table are capitalised
according to your requirements, then the selection entered in the
combobo will be as desired, regardless of the case of the characters typed.

--
Steve Schapel, Microsoft Access MVP


microsoft wrote:
Hi

I have created a combo box on a form which I have created. There are
approximately 500 entries (e.g. running from alpha to sierra) tied to the
combo/database. Is it possible that if the user wants to select kilo from
the combo they just type the first letter "k" and the combo navigates
automatically to the "k" options.

Also it is possible to force user to enter information in the form using
caps. Is there some sort of rule that I can create to allow for this.

Thanks

Hi
Thanks for responding.

My table is called symbols. There are three fields, description, symbols
and currency. This is the order in the table.

The code tied to the combo box is as follows.

SELECT [SYMBOLS], [DESCRIPTION], [CURRENCY] FROM SYMBOLS ORDER BY
[DESCRIPTION];
Bound Column:1
Column Count:3
Column Width:0";2";0"

However when I select the first letter in the name of the description the
word beginning with that letter is not automatically navigated to.

The combo box has the auto expand set to YES.

Thanks

"Steve Schapel" wrote:

The Combobox has a Property called Auto Expand. If this is set to Yes,
it will produce the behaviour you are seeking.

If all the items in the combobox's Row Source table are capitalised
according to your requirements, then the selection entered in the
combobo will be as desired, regardless of the case of the characters typed.

--
Steve Schapel, Microsoft Access MVP


microsoft wrote:
Hi

I have created a combo box on a form which I have created. There are
approximately 500 entries (e.g. running from alpha to sierra) tied to the
combo/database. Is it possible that if the user wants to select kilo from
the combo they just type the first letter "k" and the combo navigates
automatically to the "k" options.

Also it is possible to force user to enter information in the form using
caps. Is there some sort of rule that I can create to allow for this.

Thanks

I am very sorry, I can't think of any explanation for what you are
seeing here.

--
Steve Schapel, Microsoft Access MVP


microsoft wrote:
Hi
Thanks for responding.

My table is called symbols. There are three fields, description, symbols
and currency. This is the order in the table.

The code tied to the combo box is as follows.

SELECT [SYMBOLS], [DESCRIPTION], [CURRENCY] FROM SYMBOLS ORDER BY
[DESCRIPTION];
Bound Column:1
Column Count:3
Column Width:0";2";0"

However when I select the first letter in the name of the description the
word beginning with that letter is not automatically navigated to.

The combo box has the auto expand set to YES.