How do you turn off the predictive text when you’re writing criteria for queries in Access 2010? It’s making me crazy.
I want to put a “T” in the criteria, and it keeps writing Tan( and I have to backspace to get rid of the an( part.

I have come upon the same issue. In 2003 in the criteria of a query, you could type just the capital T and Access would put quotes around it if the field you were searching was text, and sometimes it would put the [] around it if it were a number, assuming that the T was going to be a pop-up asking for the parameter.

Then, of course, in 2010 you type just the T and it tries to autofill 'Tan' for you, thinking you want the Tangent function.

The only way I have found around it so far is to know what the criteria field type is, and if it is text and you want to search for T, type the " first. That way it will not think you mean Tangent, but "T".

But if there is a way to turn off the autocomplete, I would like to know it as well.