Results 1 to 2 of 2
  1. #1
    drunkenneo is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jun 2013
    Posts
    199

    Combo Problem


    Hi All,

    This is bit lengthy to explain i hope i can make understand.

    I have a combo box whose row source is order_number, when i am typin a number it gives me the any full order id started with the keyboard input number and when i enter next digit it takes value after the full order ID.

    For eg: Order Ids are:
    554
    4544
    4855
    5123

    if i need 4855, when i press 4 the combo populates to 4544 and when i press 8 it places it 45448 which is bit annoying, Please anybody can help?

  2. #2
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    I am using A2000, but the combo box as you describe it works for me. I enter 4 and the combo box displays 4544, with 544 hi-lighted. Then I enter 8 and 4855 is displayed with 55 hi-lighted.

    Do you have any code on any of the events - maybe the on change event? Or maybe a format?

    There is a property "Auto Expand" (Data tab) that could be set to NO. But that would stop the auto "find" in the row source.

    You could try:
    - Delete the combo box.
    - Save and close the form
    - Compact and Repair.
    - Open the form
    - Re-create the combo box.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Combo Box Problem
    By dccjr in forum Access
    Replies: 2
    Last Post: 11-13-2012, 09:48 PM
  2. Combo box problem
    By Lowell in forum Forms
    Replies: 2
    Last Post: 03-19-2012, 06:40 PM
  3. Combo box problem
    By CARL_ARNAIZ in forum Access
    Replies: 1
    Last Post: 05-10-2011, 08:54 AM
  4. Combo box problem
    By corystemp in forum Access
    Replies: 3
    Last Post: 06-24-2010, 09:47 AM
  5. Problem with combo box
    By osimini in forum Forms
    Replies: 5
    Last Post: 05-25-2009, 03:08 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums