combo box issue

My program has a combo box used to look up a horse by its name.  This has been working well for 6 years.  An odd symptom has been brought to my attention.  It's most repeatable when the horse's name begins with the letter "I".  Say I'm looking for a horse named Instant Equity.  When I type an "I" in the box, the first horse's name beginning with I appears ("I Dream Of Ivory").  Then when I type the next letter - an "n".  On SOME of my client's computers, the "n" will insert between the "I" and the space behind it - making it say "In Dream of Ivory" - instead of picking the first horse name beginning with "In".  My Win 7 computer shows this symptom (both with Access 2003 and 2007).  The client's server  (using Windows Server 2003) does NOT show that symptom (using Access 2003) but two of their Win 7 computers (Access 2003) do show that symptom.  Any ideas/suggestions? After first letter After second letter
KarenTaggartAsked:
Who is Participating?
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
I found the solution on the system with the issue ... and I SHOULD have known.  It's the damn Auto Correct thing ... see images:  It was actually setting that property on the Combo box to NO that finally fixed it. See image 2 below

Don't why it's an issue on some systems and not others, and only the letter "i".  I tried ALL other letters ... no problem.  Name Auto Correct.

Try it out !

mx
Capture1.gif
Capture2.gif
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Interesting.  Can you upload the db to see if we can reproduce the issue?

What happens if you type "I" followed by a Space ?

mx
0
 
KarenTaggartAuthor Commented:
I tried that and if I type an "I' then a space, it inserts another space between the "I" and the original space.

The program is actually an adp, but I pulled a couple of necessary tables and the form into an mdb.  Still seeing the symptom (so it's not SQL data related).  I removed the subforms and commented out pretty much everything, so nothing actually works, but if you play with the Find Horse combo box, you can see if the symptom shows up on your computer.

Thanks! ComboTest.zip
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
ok ... so, relative to the db you uploaded (I have it), tell me an exact sequence to type where you see the issue ...  and exactly the issue.

Not quite sure what this means"

"will insert between the "I" and the space behind it "

Behind what ..?

Also, I will try on my Win 7 machine at home w/ A2010.  This is XP with A2003.

mx
0
 
KarenTaggartAuthor Commented:
Sorry - missed a word.  When I type "I" and then a space, the combo box inserts another space after the "I" and before the original space.

So if you type "I","I Already Left" appears.  If you type any other character, the combo box inserts  the newly typed character (letter, space, whatever) between the "I" and the original space.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
ok .. just so I'm clear, what do you 'think' it should ... for this example?

mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
"If you type any other character, the combo box inserts  the newly typed character (letter, space, whatever) between the "I" and the original space"

To me, that is the expected behavior, because you have only typed one character. So, I would expect to see the next character in that position.  Am I missing something ?

mx

0
 
KarenTaggartAuthor Commented:
I never expect the type-ahead feature to insert characters - I expect it to accept the characters I type and display the first name that matches the characters I type.  Let's say you're looking for "Deadly Dasher."  You type a D and get the first horse whose name starts with D - which is "D C Slammer"..  Then you type an E and you get the first horse that starts with DE - it does not insert the E between the original D and the space after the D.. it displays "De Baba". Then type an A and it displays "Deablo~s Gal" - again, not inserting the A, just finding the first name that starts with first 3 letters.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
I get this in sequence if I type  dea

D C Slammer
De Baba
Deablo~s Gal

which is exactly what I would expect to get. So, are you not getting that ... in some cases?  
Or you are getting that, and you don't think that is correct ?

mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
ok ... there does seem to be an issue if I type

deadly
I get look ahead up to the to the 'l' in deadliest ... then look ahead stops.
I do *not* get a look ahead *after* I type the 'y', ie the look ahead stops at that point.
However, if ... I then type a Space ... Dasher then shows.  That ... is not ... what I would expect.  Is this what you are seeing/saying ?

Note however that if the list is in the drop down state, then you do see the look ahead working - hit F4 before you start typing.  Does seem to be an issue resolving the Space.

fyi ... head off to LA Fitness ... back in ~ 1.5 hrs

mx
Capture1.gif
Capture2.gif
Capture3.gif
Capture4.gif
0
 
KarenTaggartAuthor Commented:
Even if I hit F4 (or click the drop-down arrow in the combo box), when I type "I" then a space, it adds a space instead of doing type-ahead.  This client has 139 horses whose name begins with "I" and a space so I'm trying to keep them from having to scroll down that many.

An odd part of it is that if I type "A" and a space, I don't get the same symptom.  It does actually do type-ahead.  The client is saying it's not limited to horse names beginning with "I" but I can't find any others that produce the symptom.
0
 
KarenTaggartAuthor Commented:
Oh, and yes -  the typing "Deadly" example is what I expect.  Since there is a horse named just "Deadly", I expect it to show only that.  Then adding the space "types ahead" to show the first horse name that starts with "deadly ".  The only time I'm seeing the symptom is when the horse name starts with an "I" - and then, no matter what character is typed next, that character is inserted in the name that was displayed when the "I" was typed.

Try to find a horse's name that begins with an "I" using the type ahead (not the mouse, not the down arrow).  It it selecting names farther down the list or is it inserting an extra character after the initial "I"?
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
"Since there is a horse named just "Deadly"
I completely missed that!

" It it selecting names farther down the list or is it inserting an extra character after the initial "I"?

When I type a single "i" (eye, right?) ... I get what you see in the image below.

So, I would say it's not ... selecting names further down.


Capture1.gif
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
side note. If you add this code:

Private Sub Form_Load()
   
Dim x
x = Me.cboFindHorse.ListCount  ' force the combo to be fully populated

End Sub

... it will eliminate the messed scrolling of the combo when the list is dropped down, while Access continues to attempt to fully populate the list, which in your case is quite ... Large.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
ok ... just tried this on my Win 7 x64 A2010 system ... same results.  

"Flaming Jet Chick" ... dig that name !!!

btw, are you on the west coast ?

mx
0
 
KarenTaggartAuthor Commented:
Nope not west coast - Oklahoma! :o)

To see if it had to do with the massive amounts of data in the rowsource, I tried a combo box with a shorter list of names (about 700 - not unreasonable) but still had the same symptom if the horse name starts with "I"  (Yes - "eye")  Then tried it with a list of 196 - all of them ONLY horses starting with "I" - same danged symptom!  What could it be with that letter?  What puzzles me is that it does not happen when starting with a different letter that could be a whole word (like "A" or "O" - which had horses named things like "O Danny Boy")>
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
So, just checking ... based on what I've said/shown, I have not reproduced this, right?

mx
0
 
KarenTaggartAuthor Commented:
Well, I think you have.  When you type "I", then type another letter, are you seeing the newly typed letter inserted right after the "I" - but only changing the name already selected, not selecting the first name with those two letters?  Or - another way to ask - are you seeing different combo box behavior when you first type an "I" then type more letters vs typing any other first letter and typing more?  (So - are you seeing different results when you type "in" vs typing "an"?

Also - when you first type any other letter than "i", the rest of the horse's name is selected (see first image), but when you type an "i", they are not (see second image).
 Combo starting with A Combo starting with I
0
 
KarenTaggartAuthor Commented:
I just took another loook at your screen shot showing "I Already Left" - and the rest of the horse's name (after you type "i") IS selected.  So I think the symptom is NOT showing up on your computer after all.  What operating system are you using?  (Op system is the only thing I can determine different between the client's computer that shows the symptom and the ones that don't.)
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
OS
Win XP SP3, A2003 on one system
Win 7 x64 (does NOT have SP1), A2010 on another system (Office SP1)

I have one other system I can try on in a bit.

mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Well well ... on the 3rd system ... XP SP3, A2003 - which should in theory be the same as my other laptop - I get the issue (see image), and it seems only with the letter "i" (upper or lower case).  I type an "I" ... and that results in what you see in the image, different in the previous image I posted.

What I see happen is ... there is a momentary brief flash of correct highlighting/select of the remain text, then it goes away. I've seen this before.  I suspect - it is some minor difference in display drivers.  And there was one instance with it did select properly.  Go figure.

I will mess with it later more ...

mx
RoboScreenCapture.jpg
0
 
KarenTaggartAuthor Commented:
Thanks.  At least the symptom is appearing for you on that computer!  I have noticed the flash, but don't know what to make of it.
0
 
KarenTaggartAuthor Commented:
YOU ROCK!!!  Thank you so much!!
0
 
KarenTaggartAuthor Commented:
That turning off "Auto Correct" for the combo box worked like a charm! I've worked with Access for over 15 years and never even realized that was there!
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
:-)
I tried every possible setting, different fonts, you name it.  Suddenly it HIT me!

The individual control version of Auto Correct is usually ... not a problem. But from now on, I'm turning it off for ALL controls!

mx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.