Re: Combo box auto populate problem with CAPS

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Version is Access 2002 sp3. No events at all associated with any of the combo
boxes. They all behave this way. In every one of my databases. It's like the
second you type a character that it can't find, it displays the wrong
character in upper case, inserted into the middle of the string of the found
text.

"Dirk Goldgar" wrote:

"slickdock" <slickdock@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:421CBE9B-5460-4100-8B77-A79EFFDDBA37@xxxxxxxxxxxxxxxx
Sorry, Yes, I mean autoexpand, not auto populate.
The choices in the combo box may be any combination: Upper case, lower
case,
or a mix.

What I mean by unpredictable is hard to put into words, but I'll show
examples:
Lets say Beard is in the list. But Beeman is not in the list.

If I type in all caps "BEA", the field auto expands to "Beard" properly.

If I type in all lower case "bee", I see "bee", as you would expect to see
when you don't have a match. Then I can easily backspace the second "e"
to
find a correct match.

If I type in all caps "BEE", I see "BeEard". My cursor is then resting
after
the capital E, then I have to delete forward and backward to erase
everything
in the box before I can start finding a valid entry.

So the problem seems to be limited to the not in list behavior.


Interesting. I can't reproduce this on a very simple test form, using
Access 2003. What version of Access are you using? Is there any code (or
macros) associated with the combo box's events?

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)


.

Relevant Pages

  • Re: Combo box auto populate problem with CAPS
    ... find a correct match. ... When caps lock is off, ... Does your combo box contain entries that differ only in case (upper vs. ... Dirk Goldgar, MS Access MVP ...
    (microsoft.public.access.formscoding)
  • Re: Help needed [Logical operations in HLA/HYDE]
    ... The correct way to change upper to lower caseor lower to upper is best ... Then you talke the value of the character of say ta lower case symbol ... Here is the part I can show you of the ascii table used in ... Some langauges have accents on som of the the letters too! ...
    (comp.lang.asm.x86)
  • Re: Is there any way to say ignore case with "in"?
    ... the same character, as the character is already in lower case. ... Instead of 15 exceptions to the rule, conversion to upper has only 5 ... The other effect would be conflating physics' Angstron unit and Kelvin unit signs with ring-a and K. Applicaton programmers beware. ...
    (comp.lang.python)
  • Re: Exercise 7-1
    ... Your indentation is inconsistent and doesn't correspond either to the ...     int c; ... to upper case if it's invoked as "upper", ... while loop to read each character from stdin, ...
    (comp.lang.c)
  • Re: HAVE TRIED BUT CANT SEEM TO GET IT RIGHT
    ... I placed it on the sub form on Got Focus. ... >> character after sql statement. ... so it thinks the SQL statement has ... > Dirk Goldgar, MS Access MVP ...
    (microsoft.public.access.formscoding)