L
Larry
I have a travel database. The database contains a table of airlines our
engineers may fly. The application has a form with a combo box that allows
the travel coordinators(TC) to select the airline. This combo box shows the
airline name (as entered by the TC's), but returns the airline ID (which is
hidden from the users of course). The TC's like the feature that allows them
to start typing the airline name and it fills out the rest of the name in
the combo box.
Sounds simple and boring.... so far.
The problem I have, is that three of the airlines start with the word "Air".
When an "A" is entered in the combo box, the first "AIR" airline is shown in
the combobox, but the text is NOT selected. Meaning that when you type the
"I", it inserts it between the "A" that was typed and the "I" that came up,
so that you end up with "AIIR"!
All other letters seem to function (type "B", and British Airways is
displayed and selected) and so on with all the other first letters of
airlines.
I have tested this in other combo boxes, even typing the names into a
combobox instead of having it selected from the query. But every time I do
this, whether from the table, query, or typed into the combobox as a list,
it does the same thing.
I would like to know if this is happening to others with the same version
(Access 2002 SP2, Windows XP).
If you create a form (doesn't even need a table), with a combobox (one
column is fine) and type in the following values:
Air Cargo Netherlands (ACN)
Air China (CA)
Air France (AF)
British Airways (BA)
If you type a "B" in the combobox, it appears to work correctly. If you type
an "A" though, it doesn't work (at least for me).
I have tested so many different combinations of values that I am worn out
and give up. I hope someone can help me figure this out.
Thanks
Larry
engineers may fly. The application has a form with a combo box that allows
the travel coordinators(TC) to select the airline. This combo box shows the
airline name (as entered by the TC's), but returns the airline ID (which is
hidden from the users of course). The TC's like the feature that allows them
to start typing the airline name and it fills out the rest of the name in
the combo box.
Sounds simple and boring.... so far.
The problem I have, is that three of the airlines start with the word "Air".
When an "A" is entered in the combo box, the first "AIR" airline is shown in
the combobox, but the text is NOT selected. Meaning that when you type the
"I", it inserts it between the "A" that was typed and the "I" that came up,
so that you end up with "AIIR"!
All other letters seem to function (type "B", and British Airways is
displayed and selected) and so on with all the other first letters of
airlines.
I have tested this in other combo boxes, even typing the names into a
combobox instead of having it selected from the query. But every time I do
this, whether from the table, query, or typed into the combobox as a list,
it does the same thing.
I would like to know if this is happening to others with the same version
(Access 2002 SP2, Windows XP).
If you create a form (doesn't even need a table), with a combobox (one
column is fine) and type in the following values:
Air Cargo Netherlands (ACN)
Air China (CA)
Air France (AF)
British Airways (BA)
If you type a "B" in the combobox, it appears to work correctly. If you type
an "A" though, it doesn't work (at least for me).
I have tested so many different combinations of values that I am worn out
and give up. I hope someone can help me figure this out.
Thanks
Larry