Combo Box with Caps Locki

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?



--
 
B

bw

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
 
B

Bill Mosca, MS Access MVP

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top