troubleshooting Question

Dropdown Autofill Error When Caps ON

Avatar of APD Toronto
APD TorontoFlag for Canada asked on
Microsoft AccessVB ScriptVisual Basic Classic
5 Comments1 Solution371 ViewsLast Modified:
Hello Experts,

I have a rather strange incident occuring in my Access dropdown controls, that i'll try to explain.

Lets say i have a dropdown with the following values:


Normally, when caps lock is off and i start typing app each letter is overwriten until the user finds a match, as it is expected.

However, when caps is on and i start typing APP the first p is converted to lower-case and the autocorect icon pops up, however the second i type in the 3rd letter it contines caps, and the dropdown stops overwritting, so i end up with ApPLESples

How come it stops replacing? Is there an easy fix to this, or should i have on every dropdown's gotFocus turn-off caps.  I'm not even sure if this is possible?  

Any thoughts?
Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros