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 04, 2020

jam_eno 
I'm glad you found the answer, even if it's not the optimal solution.

I wonder if there's not a different way to highlight the cursor, perhaps color or size, that would help tracking it without the unfortunate side effect.

jam_eno's avatar
jam_eno
Copper Contributor
Oct 05, 2020

George_Hepworth 

I have tried the cursor size setting and it helps. I was experimenting with the Text Cursor Indicator. The advantage of the TCI is that it doesn't obscure the text at the point of entry.

The irony is that the TCI didn't even work in Access. It works in the other MS Office applications: Word, Excel , Notepad and the Command window

Resources