I have a data entry form, that has 2 combo boxes on it.
These two boxes use the same query for data.
It's a query of names (lastname, firstname).
There are about 2500 names in the query. It is grouped (this happens if it's grouped or not) so that each name only appears once. They can be in there more than once because of a third field that is used later.
Here's the weird part.
I have only documented this to happen with one name.
The last name is Freitag
Here are a few people in the list
Freitag, Alisha
Freitag, Ben
Freitag, Bill
Freitag, Leah
Freitag, Rebecca
Let's say I want to enter Freitag, Leah in this field.
WHen I start to type in that field, Frei the first name that matches that in the list will appear (highlighted completely) Frietag, Alisha. I should be able to continue typing but once I type in the t it turns into an edit and I am typing in the middle of Freitag, Alisha name.
It's hard to describe because it's very visible.
Does anyone know if the key combination FREIT means anything unapparent to me that would cause something like this to happen? I know that really must sound weird to some of you, but it appears that when freit (any kind of combination of upper/lower case letters) is entered into this field (either of the two combo fields) it's almost like it's been sent a subliminial command to go into edit mode.
If I start to enter any other name, it will just continue until I either select the one that is at the top of the list, or I use the drop down to pick from the list.
I am using Vista, with and Access 2000 mde file. THe same thing happens with the mdb file.
When start to enter the name in the field, the first person in the list appears. This is correct.
These two boxes use the same query for data.
It's a query of names (lastname, firstname).
There are about 2500 names in the query. It is grouped (this happens if it's grouped or not) so that each name only appears once. They can be in there more than once because of a third field that is used later.
Here's the weird part.
I have only documented this to happen with one name.
The last name is Freitag
Here are a few people in the list
Freitag, Alisha
Freitag, Ben
Freitag, Bill
Freitag, Leah
Freitag, Rebecca
Let's say I want to enter Freitag, Leah in this field.
WHen I start to type in that field, Frei the first name that matches that in the list will appear (highlighted completely) Frietag, Alisha. I should be able to continue typing but once I type in the t it turns into an edit and I am typing in the middle of Freitag, Alisha name.
It's hard to describe because it's very visible.
Does anyone know if the key combination FREIT means anything unapparent to me that would cause something like this to happen? I know that really must sound weird to some of you, but it appears that when freit (any kind of combination of upper/lower case letters) is entered into this field (either of the two combo fields) it's almost like it's been sent a subliminial command to go into edit mode.
If I start to enter any other name, it will just continue until I either select the one that is at the top of the list, or I use the drop down to pick from the list.
I am using Vista, with and Access 2000 mde file. THe same thing happens with the mdb file.
When start to enter the name in the field, the first person in the list appears. This is correct.
