Combo Box Auto Fill-In Problem

  • Thread starter Thread starter Kathy Webster
  • Start date Start date
K

Kathy Webster

Since I have switched from Access 2000 to Access 2002, the auto fill-in
feature of combo boxes on all my forms is behaving improperly. This is hard
to explain in words...I'll do my best:

I start typing in the combo box, and it starts auto-filling-in a match from
the Row Source. After typing a few characters, the Auto Expand property
fills the field with a match. Then I continue typing more characters.
Instead of changing to the right match, it inserts my new text into the
existing match, making a complete mess of things... let me try giving an
example:

I start typing in the combo box:
Jo

I see it expand in the box to:
John

But I want "Joseph," so I continue typing:
s

I see, in the box:
Joshn

It is as if, once it finds a match, the next character I type gets INSERTED,
rather than replacing the first match with the new match. So then, of
course, I have to manually delete the "hn" before it can find "Joseph."

This same combo box with the same properties worked fine in Access 2000. It
is not just one combo box on one form...it is throughout the database, on
various forms, various combo boxes with various Row sources. It happens if
the drop-down is open or closed--it doesn't make a difference. The
properties of the combo box are:

Row Source Type: Table/Query
Row Source: q_FirstNameLookup
Column Count: 3
Column Heads: Yes
Column Widths: 2"; 1"; 4"
Bound Column: 1
List Rows: 15
List Width: 7:
Limit To List: Yes
Auto Expand: Yes

Any help will be appreciated!
Kathy
 
Kathy said:
Help! Is anyone out there to help me?
Thank you!
Kathy
Click to expand...

I thought that I first saw that behavior in Access 2000 when comparing it to
Access 97, but I cannot reproduce it now.

I created a test file in Access 97 with a ComboBox using the same entries as
in your example "John" and "Joseph". I then tested it in Access 97, Access
2000, Access 2002, ands Access 2003 and the entry correctly jumped to
"Joseph" once I typed the "s" and it did not insert the "s" inside of "John"
as you are describing.

I can't remember the missing piece of the puzzle, but I definitely have seen
this behavior before and I am almost certain it was in Access 2000.
 
My database does the same thing, but only if the capital lock is left on.

Try it with the cap lock off.
 
Back
Top