Why does query convert "Like" criteria to "ALike"

[dishrag86]

Sometimes queries seem to go corrupt and when I type "Like" (without quotes)
into my criteria as soon as I click out of that criteria, it changes to
"ALike". Any ideas?

 

[Allen Browne]

Uncheck the option to use "SQL Server Compatible syntax."

In Office 2007, click the Office button (top left) and then Access Options
(bottom of dialog.)

In earlier versions, it's Tools | Options.