Dropdown Autofill Error When Caps ON

APD Toronto
APD Toronto used Ask the Experts™
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?
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016

look at the dropdown's keydown, keypress or keyup events.
see if there are any codes run on those events.
APD TorontoSoftware Developer


No, the only dropdown event is LostFocus
Top Expert 2016
try doing compact and repair
Tools >Database utilities > compact and repair database

if problem persists,
* do a decompile
   see this link

* after that, create a blank db and import all objects
* open the VBA window and do
     Debug > Compile
     correct any errors raised

* do a compact and repair
Nothing to do with a Corruption, its problably caused by Allow Autocorrect property.

Set the this on NO.

APD TorontoSoftware Developer


Cool, it worked!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial