weird glitch with combo box

[Jeri]

This is a mystery I can't seem to figure out. I'm using Access 2007. I have a
combo box that works beautifully with one exception. This combo box brings up
a list of genus and species of plants. Limit to list is set to yes.

The genus is supposed to be capitalized, but we mostly just type it in lower
case and when it autofills and I leave the field, it's properly capitalized.
However, with any species beginning with an "S", I have to use a capital S,
or the dropdown box won't autofill properly.

Here's an example. when I enter "g", the species "Galeopsis tetrahit" comes
up. If I add an "e", the species "Gentianella amarella" is suggested. That's
how it's supposed to work. When I enter "s", the species "Salix amygdaloides"
is suggested, as that's the first species that begins with an s. But if I am
trying to enter the species "Schizachyrium scoparium", and add a "c" it
inserts the "c" in the midst of the first species, like this -- "Scalix
amygdaloides". The only way around this is to capitalize the "S". I know
this, but others are frustrated by the inconsistency.

It's just such a bizarre glitch, I wondered if anyone had any ideas about
what's going on. The species list is growing, and there are a lot of plants
whose genus begin with "S".

Thanks in advance for any suggestions.

 

[June7 via AccessMonster.com]

The RowSource list is based on table field of actual data that is querying
for all DISTINCT instances of values? In the combobox dropdown is there an
entry for "Scalix ..."? If so, someone as made an entry with misspelling. Go
find the record with this entry and correct the spelling.

 

[Jeri]

Nope. That isn't it. No such entry exists. That's what makes this so weird.
If I enter Salix, it works. If I enter "salix", it does not. But all other
beginning letters work fine.

 

[June7 via AccessMonster.com]

Okay, is very bizarre. Best I can offer now is to look at your project if you
want to drop here:
http://www.box.net/shared/0mfqudj3nz

Nope. That isn't it. No such entry exists. That's what makes this so weird.
If I enter Salix, it works. If I enter "salix", it does not. But all other
beginning letters work fine.

The RowSource list is based on table field of actual data that is querying
for all DISTINCT instances of values? In the combobox dropdown is there an

[quoted text clipped - 24 lines]

 

[Dirk Goldgar]

This is a mystery I can't seem to figure out. I'm using Access 2007. I
have a
combo box that works beautifully with one exception. This combo box brings
up
a list of genus and species of plants. Limit to list is set to yes.

The genus is supposed to be capitalized, but we mostly just type it in
lower
case and when it autofills and I leave the field, it's properly
capitalized.
However, with any species beginning with an "S", I have to use a capital
S,
or the dropdown box won't autofill properly.

Here's an example. when I enter "g", the species "Galeopsis tetrahit"
comes
up. If I add an "e", the species "Gentianella amarella" is suggested.
That's
how it's supposed to work. When I enter "s", the species "Salix
amygdaloides"
is suggested, as that's the first species that begins with an s. But if I
am
trying to enter the species "Schizachyrium scoparium", and add a "c" it
inserts the "c" in the midst of the first species, like this -- "Scalix
amygdaloides". The only way around this is to capitalize the "S". I know
this, but others are frustrated by the inconsistency.

It's just such a bizarre glitch, I wondered if anyone had any ideas about
what's going on. The species list is growing, and there are a lot of
plants
whose genus begin with "S".

Thanks in advance for any suggestions.

I have seen something like this before, but I'm darned if I can remember
exactly what caused it. Do you have any code any of the events of the combo
box? If so, what is it?

 

[Mike Painter]

news:[email protected]...

I have seen something like this before, but I'm darned if I can
remember exactly what caused it. Do you have any code any of the
events of the combo box? If so, what is it?

When ther are a large number of values in the source, most of my apps stop
responding around "s" or "t" and it is necessary to filter the sleection in
some way to get below what seems to be a 64k limit.