Forum Discussion

jam_eno's avatar
jam_eno
Copper Contributor
Sep 30, 2020
Solved

Access 365 version 2009 build 13231.20262 query design view syntax error

When I start entering text in the criteria box of the query design view, Access starts making auto-corrections then tells me there is a syntax error. Annoying enough, but the error dialog box will no...
access
  • jam_eno's avatar
    jam_eno
    Oct 05, 2020

    For clarity to anyone with the same problem, the solution for me was to turn off the Text Cursor Indicator in the "Ease of Access" settings.

     

    Thanks to George_Hepworth who put me on the right track

George_Hepworth's avatar
George_Hepworth
Silver Contributor
Oct 03, 2020

jam_eno  It's been a couple of days. Have you found a solution?

 

If not, I am looking at that screen shot and seeing what appears to be a cursor placement problem. It looks like, perhaps, you started typing and the cursor hopped back to the initial position for your next letter, leading to the impasse.
When I've seen that problem it boiled down to a timer event running in a form. Disabling that timer eliminated the hopping cursor.

If you have no timer events and if you haven't yet found another solution, post back.

jam_eno's avatar
jam_eno
Copper Contributor
Oct 05, 2020

For clarity to anyone with the same problem, the solution for me was to turn off the Text Cursor Indicator in the "Ease of Access" settings.

 

Thanks to George_Hepworth who put me on the right track

Resources