Why Does My Query Change Like To Alike?

“…everytime i save my query, the like function always turn to Alike…”

ALike “*” & [Forms]![FORMsearch]![FIRSTNAME] & “*”

should be:

Like “*” & [Forms]![FORMsearch]![FIRSTNAME] & “*”

“Like” kept changing to “Alike”!

This was an interesting question I received.

Well come to find out that this has to do with an Access setting related to “SQL Server Compatible Syntax (ANSI 92)”

When you remove the check from the checkbox on “This Database”, the conversion from “Like” to “Alike” won’t take place!

(again, if the check box is dimmed, you will need to close any open query windows you have.)

Hope this helped!

Free! Subscribe To Our YouTube Channel!

facebooktwittergoogle_plusredditpinterestlinkedinmailby feather


Call Erik Now