Forum Discussion
Access SQL Syntax Highlighting, Autocomplete, and Formatting
I just had Access (the newest version with Office 365) lose all syntax highlighting, autocomplete, and the formatting that had been allowed previously. It worked last night, and this morning it was all gone. The issue is on my Windows 10 desktop. It still highlights syntax and formats for readability on my Win 11 laptop.
The only thing I can find between the two versions that is different is there is a checkbox for the Monaco query editor in Access on my laptop, but not my desktop.
I would like to reiterate that it was fine last night on the desktop. I opened the same database this morning, and it was gone. I checked other databases, they all lack the highlighting and formatting on my desktop, but it is still there on my laptop.
I attempted to update, repair, and reinstall office, and nothing changed.
I am trying to determine what might have caused this, and if there is anything to do about it. The highlighting, autocomplete, and formatting are not a complete necessity, but they made working with the queries a lot easier for me, since I am a not particularly experienced with SQL.
2 Replies
Hi,
The usual reason why you don't see the Monaco checkbox in the options of Access 365 are the security settings. You either have to put the database in a Trusted Location or make it a Trusted Document or enable all macros to make the Monaco option visible. All these settings can be done in the Trust Center.
Servus
Karl
****************
Access Forever News DevCon
Access-Entwickler-Konferenz AEKHere's the key:
" ... there is a checkbox for the Monaco query editor in Access on my laptop, but not my desktop."
The Monaco query editor is actually the feature that supports enhancements to the SQL editor.
If you do not even have the checkbox to enable Monaco SQL Editor available in the version of Access on your computer, that would probably indicate it is actually an older version of Access, not M365. If it is there, check it to enable Monaco.
Can you verify the version of Access on both in case you don't see the option for Monaco?
You'll find it under File-Account.
