Avatar of APD Toronto
APD TorontoFlag for Canada

asked on 

Dropdown Autofill Error When Caps ON

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:

Apples
Appricots
Oranges


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?
Microsoft AccessVB ScriptVisual Basic Classic

Avatar of undefined
Last Comment
APD Toronto
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

look at the dropdown's keydown, keypress or keyup events.
see if there are any codes run on those events.
Avatar of APD Toronto
APD Toronto
Flag of Canada image

ASKER

No, the only dropdown event is LostFocus
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of danishani
danishani
Flag of United States of America image

Nothing to do with a Corruption, its problably caused by Allow Autocorrect property.

Set the this on NO.

HTH,
Daniel
Avatar of APD Toronto
APD Toronto
Flag of Canada image

ASKER

Cool, it worked!
Microsoft Access
Microsoft Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo