disable autocomplete in query designer
Allow user to disable the autocomplete in the criteria section of the query designer. When entering a string or number into the criteria you have to hit escape in order for it to not enter a completely unrelated query or table. Good idea in principal, but not executed correctly. Require a (ctrl+space or other hot key) or allow the user to turn this feature off.
Ken Ismert commented
It is too easy to get into a fight with this feature. I know what I want to type, but autocomplete thinks different! We go back and forth, until I finally pound it into submission. This feature is an irritation and waste of time.
"bit Intellisense" >> but Intellisense
I get it for sure, bit Intellisense is a relatively new feature in the Query Designer ... and the Intellisense goes several levels deep - amazing - like reference a control on a subform of a main form.
If I had to choose between the two, I would definitely choose Intellisense.