Hello All. I am setting up a form that uses the Access default "Find Combo Box" It is searching through my list of customers so that the user can select the customer they want to continue through the order taking process with. I have tested a number of the customers to make sure the combo box is working properly, and have found only one error.

I have a customer called "Three Dollar Cafe - Location." There are 4 or 5 different locations. When I start to type in my combo box, "T - H - R" Normally it would display "THR" with the rest highlighted "EE DOLLAR CAFE - LOCATION". But instead it is displaying "THR" then just adds the rest in "EE DOLLAR CAFE - LOCATION" with no highlighting. so if I were to accidtently go farther and type "T - H - R - E" the combo box would display "threee dollar cafe - location" (an extra 'e' has been added). Secondly, if I only type the "THR" it displays "three dollar cafe - location" but when I hit enter, or click it, it gives me the message "The Text you entered isn't an item in the List" Thirdly, it always shows the first location in the list, so if I wanted the second or third location, I would normally drop down the combo box, and find the next location on the list, however, the combo box is stuck at the top of the entire list. Its very strange and it only does this when I am trying to find a "Three dollar cafe" So essentially it only does it when I type "THR"

Any help would be very much appreciated. If my DB is necessary to help, let me know, I'll copy and paste it into a new DB that isn't as big and doesn't have private info. Thanks so much in advance.