Combobox text display error

Discussion in 'Access Forms Coding' started by Hoop, May 1, 2008.

  1. Hoop

    Hoop Guest

    Anyone come across this? With capslock on, typing into a combobox after a few
    letters are typed in, the text in the combobox fleshes itself out, but not in
    the normal way.

    The normal way is for Access to display in the combobox the first entry in
    the list that starts with the letters typed in by the user eg type in "ha"
    and the text in the combo box might display "Hackett Craig" if that is the
    first entry in the list that begins with the letters "ha".

    But what's happening in this situation is after "ha" is typed in, the "w" is
    typed in (so the first 3 letters typed in are now "haw", the text displayed
    in the combobox is "HaWckett Craig" - and there is no such name in the combo
    box list.

    However, there ARE names in the list beginning with "haw" but these are not
    automatically displaying, which you would expect them to. Wierd.
     
    Hoop, May 1, 2008
    #1
    1. Advertisements

  2. Hoop

    Guest

    On Thursday, May 1, 2008 6:39:06 PM UTC-4, Hoop wrote:
    > Anyone come across this? With capslock on, typing into a combobox after a few
    > letters are typed in, the text in the combobox fleshes itself out, but not in
    > the normal way.
    >
    > The normal way is for Access to display in the combobox the first entry in
    > the list that starts with the letters typed in by the user eg type in "ha"
    > and the text in the combo box might display "Hackett Craig" if that is the
    > first entry in the list that begins with the letters "ha".
    >
    > But what's happening in this situation is after "ha" is typed in, the "w" is
    > typed in (so the first 3 letters typed in are now "haw", the text displayed
    > in the combobox is "HaWckett Craig" - and there is no such name in the combo
    > box list.
    >
    > However, there ARE names in the list beginning with "haw" but these are not
    > automatically displaying, which you would expect them to. Wierd.
     
    , Nov 19, 2013
    #2
    1. Advertisements

  3. Hoop

    Guest

    The solution (just discovered after years of aggravation!): Change the combo box's "Allow Autocorrect" property to NO. That property is listed under "Other".

    pemigh
     
    , Nov 19, 2013
    #3
  4. Those of us who've been around the product for a long time tend to call that
    feature "Autocorrupt" and advise, unless you feel a compelling need, to turn
    it off for every database. Though I don't have any "inside information" on
    design decisions made by the Access team, I suspect it's one of those
    "flashes of brilliance" by someone in the design team that was implemented
    and actually used by enough "enterprise-level" customers that Microsoft
    decided not to take it out even though it is, more often, a PITA than a
    help.

    --
    Larry Linson
    Microsoft Office Access MVP
    Co-Author, Microsoft Access Small Business Solutions, Wiley 2010

    <> wrote in message
    news:...
    > The solution (just discovered after years of aggravation!): Change the
    > combo box's "Allow Autocorrect" property to NO. That property is listed
    > under "Other".
    >
    > pemigh
     
    Access Developer, Nov 19, 2013
    #4
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Pat
    Replies:
    8
    Views:
    179
  2. Christine
    Replies:
    6
    Views:
    258
    Christine
    Oct 10, 2004
  3. Rich J

    Combobox rowsource based on value of other combobox

    Rich J, Nov 9, 2004, in forum: Access Forms Coding
    Replies:
    0
    Views:
    185
    Rich J
    Nov 9, 2004
  4. disneygoof via AccessMonster.com

    ComboBox: Update a value in current record before changing the ComboBox Value

    disneygoof via AccessMonster.com, Mar 7, 2008, in forum: Access Forms Coding
    Replies:
    1
    Views:
    204
    miss031
    Mar 8, 2008
  5. Shane
    Replies:
    1
    Views:
    183
    Brendan Reynolds
    Apr 22, 2008
  6. Associates

    combobox value depends on other combobox

    Associates, Apr 24, 2008, in forum: Access Forms Coding
    Replies:
    1
    Views:
    186
    Daniel Pineault
    Apr 24, 2008
  7. MP
    Replies:
    1
    Views:
    247
    Arvin Meyer [MVP]
    Dec 20, 2008
  8. Hal Levy
    Replies:
    6
    Views:
    289
    Dirk Goldgar
    Jul 31, 2009
Loading...