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 don't have a problem with that very often. What I usually do is just continue typing the value I really want to use as a criteria. Access gives up when it is clear that you're not looking for the default offered. I don't think you really need to backspace to do that.

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.

As noted, what I've found is that you just continue to type, as you normally would, without responding to the suggested text, and Access quickly gets the point.

thx all ! (IMG:style_emoticons/default/grin.gif)