Case Problems with Drop-Down

[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

 

[Vic Spainhower]

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

 

[Guest]

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.

 

[Vic Spainhower]

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

 

[Guest]

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.

 

[Vic Spainhower]

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

 

[Guest]

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.