This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(240, 78%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
Within the past couple of weeks, users of multiple Access databases have experienced instances of the Advanced Filter/Sort and Toggle Filter not working (greyed out). The forms have an underlying query and when you go into Advanced Filter/Sort, Access thinks you're in a query, not a filter. The query options are all available, but the filter options are not. We have experienced this across multiple databases, and restarting Access sometimes fixes the issue, and sometimes it doesn't. In fact, a user will be in the database in the morning working fine, and reopen the same database in the afternoon and lose the Advanced F/S functionality.
This seems to be a bug, but curious if anyone else has experienced it. The Advanced Filter/Sort is being open by macro from the form, and the underlying query appears correctly. No other changes have been made to the structure of the databases or data. Version of Access is 2510 (Build 19328.20178 Click-to-Run), Current Channel.
A family of Microsoft relational database management systems designed for ease of use.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(307.2, 10%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEN%3C/text%3E%3C/svg%3E)
I've also experienced the same issue - Advanced Filter/Sort and Toggle Filter not working (greyed out).
Answer accepted by question author
Hi,
I reported the problem to the Microsoft Access team. They identified it as a current bug that will be fixed soon. Meanwhile the workaround to get the normal filter functionality is to disable Monaco:
File > Options > Current Database > Uncheck the box at Enable Monaco SQL Editor
Servus
Karl
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(224.00000000000003, 34%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
I remember also experiencing this complaint/problem. and the it was gone, presumably with a bug fix. now something very similar is happening again. advanced filter won't work, but this time no graying out of toggle.
We have been informed by Microsoft that a change was made to address this problem for Current Channel.
If you are in Current Channel, you only have to restart Access and the problem should be resolved.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 68%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWN%3C/text%3E%3C/svg%3E)
I've now had 6 computers progressively affected by this bug over the last 2 weeks. All Windows 10, office 365 click to run. They were all on 1 of the last 3 releases. It was user-specific - on two computers each with 2 user accounts 1 user was affected and 1 wasn't. Users didn't need to either log out or shut and re-open Access for the problem to occur - one user had a normal advanced filter/sort available, and an hour later, that functionality had been lost. I have fixed this issue by rolling back to a January 2025 version of Office 18324.20194.
This issue is not linked to the database - the same database could be opened by different users, one affected by the bug, and one not affected.
Microsoft Office Support have said that this falls outside the scope of their support services and recommended reaching out to the Office or Microsoft 365 support team directly
I just posted a comment mentioning that this problem with Advanced filter appears to be back. Only now without the graying out of toggle filter. When I hit Add Comment, the whole MS Help website crashed. Had to start all over. 3 times now.
Can you provide a repo database for review?
If so, remove any sensitive personally identifying information first.
Upload it to a sharing site like DropBox or OneDrive.
Also, specific the version and build of Access you are using.
I can try to obtain a repo database, but it will take some time to remove the portions that we would want to remove. Access Version is 2510 (Build 19328.20178 Click-to-Run), Current Channel. But replication of the issue is not consistent. A user today was in a database in the morning working fine, and reopened the same database in the afternoon and lost the Advanced F/S functionality.