Im searching for a particular customer to create a Work Order.  The dropdown is a lookup of Customer_Name from another form. Lets say I want to find a customer named "Fletcher's Jewelers (Colonial Heights)". If I start typing in the Dropdown Search field, the text "fletcher's", all of my accounts begenning with "Fletcher's" appear in a list. If I then type "fletcher's j", all of my "Fletcher's Jewelers"  customers disappear. Why is that? It doesnt seem right. I have a Ton of customers that start with "The". Will I have to train all of my employees to not type the when looking for customers like "The Auto Connection"?