Case Problems with Drop-Down

  • Thread starter Thread starter Vic Spainhower
  • Start date Start date
V

Vic Spainhower

Hello,

I have an Access 2002 form that contains several combo drop-down menus. I
have set it to dropdown automatically on the enter event of the control. The
data on these are names containing proper case formatting. On one of these
menus if the CAPS lock is on it will begin inserting upper case letters
beginning with the 3rd letter instead of staying on the matching name. In
other words if the table contains Delta Airlines, Inc. for the combo box.
and the user starts typing DELT it will show DeLTlta Airlines, Inc. where
the user is typing.

Does anyone have any ideas why this behaviour? The other combo box on the
same form doesn't behave this way so there must be a property setting I
would presume.


Thanks very much!

Vic
 
The other combo box on the same form doesn't behave this way so there
oops - I was wrong - they both behave the same way!!


Vic
 
That is normal behaviour. Don't worry about it. As soon as the user hits
Enter or Tabs out of the combo, it will display exactly what is in the table.
 
Not true, get the error message "The text you entered isn't an item in the
list"!. I've done some more checking and this same behaviour exists in
Access 2003. Here's what I did:

1. Setup a test Access 2003 database with one table called tblNames -

empID Autonumber
empName Text (50)

2. Typed in 2 names:

JOHN DOE
Joe Blow


2. Setup an unbound form with a combo box for the tblNames

If the CAPS lock is off it works correctly. on both names. However, if the
CAPS lock is on it will fail on Joe Blow


Wierd ...


Vic
 
Sorry, never have seen that happen. In fact, before I posted, I tested one
of my forms for that behaviour. It does visually exactly what you describe;
however, I got the correct record with the correct value.
 
Kltauu,

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

Thanks for helping out!

Vic
 
Oh, yeah, I forgot about those. I always leave the autocorrect options off.
Glad you figured it out and let me know, I was puzzled about that.
 
Back
Top