Combo Box with Caps Locki

  • Thread starter Thread starter bw
  • Start date Start date
B

bw

I have a table of names as follows:
tblName NameID Name
1 Albert Johnson
2 Brian Joplin
3 Chris Emanual
4 Daniel Porter


I have a form with a combo box that looks up values in the table
tblName.
If I type "albert" into the combox field, Albert Johnson is
automatically displayed in the box.
With Caps Lock on, when I type "ALBERT" in the box, then "AlBERTbert
Johnson" is displayed in the box (and of course is not an item in the
list).

Why does this happen with Caps Lock on, but not with lower case?
How can I prevent this from happening when Caps Lock is on?



--
 
I searched, and searched and searched, and finally found the problem to
my dilemma.

In a post from Vic Spainhower on August 25, 2006, who was having the
same problem, he writes:

"It's AutoCorrect that causes this behavior! I went to
Tools/Options/Spelling - Autocorrect Options and unchecked all of the
capitalization options and it now works!"

Sure enough, it now works for me too.
Bernie
 
Thanks for posting the solution. That AutoCorrect is just not very useful in
a database application. I can see its use in Word, but, in Access, it causes
more problems than not.

--
Bill Mosca, MS Access MVP


bw said:
I searched, and searched and searched, and finally found the problem to my
dilemma.

In a post from Vic Spainhower on August 25, 2006, who was having the same
problem, he writes:

"It's AutoCorrect that causes this behavior! I went to
Tools/Options/Spelling - Autocorrect Options and unchecked all of the
capitalization options and it now works!"

Sure enough, it now works for me too.
Bernie
Click to expand...
 
Back
Top