Access 2007 autocorrecting query criteria

N

nsh

When I enter criteria in a query in Design mode, such as Not like "box*"
Access is changing Like to Alike which fails to return the correct response.
Like=>Alike is not listed in the autocorrect list. The database is in
Access 2000 format so its accessible on a range of older machines.

Any ideas?
 
P

pietlinden

When I enter criteria in a query in Design mode, such as Not like "box*"
Access is changing Like to Alike which fails to return the correct response.
Like=>Alike is not listed in the autocorrect list. The database is in
Access 2000 format so its accessible on a range of older machines.

Any ideas?
Click to expand...

turn off Name AutoCorrect. Allen Browne has information about it on
his website. www.allenbrowne.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

why does access 2007 convert "Like" to "Alike" in my query? 1
Like criteria changing to ALike 3
'Data Type Mismatch In Criteria Expression' error when using 'Count' in query Design; Help! 0
Strange query behaviour in Access 2007 7
Wild card not working in Access 2010 query 4
New computer, how do i move outlook 365 ENTIRELY? 0
Using "like" query from and external link to Access 1
MS Access query filter problem 1

Top