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(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 have had a data filter setup under advanced filter/sort for years now. Always there and worked well. Now access is saying it can't find that filter. Why? What happened and how can it be restored?
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(41.6, 25%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGN%3C/text%3E%3C/svg%3E)
Hello Dave
Thank you for posting your question on the Q&A Forum.
Based on my research, your issue may be related to a behavior reported by other users where they simply try to use the Advanced Filter/Sort on a form, but the Toggle Filter option is unavailable or greyed out.
If this matches your scenario, you can try switching to a query-based report by creating a query with your desired filter criteria and using it as the record source for your report. Another option is to use VBA to open the report with a filter, which allows you to apply filters programmatically when opening the report.
If you’re working with a large dataset, go to File > Options > Current Database, scroll to Filter Lookup Options, and increase the record threshold (for example, from 1000 to 20000) to ensure filters display correctly. Some users have also resolved this issue by reverting to Microsoft Office 365 Version 2412 (Build 18324.20168), released on January 7, 2025.
For more details, please refer to this thread: Unable to filter reports in Microsoft Access database
If this applies to your case and you’re not familiar with VBA, please comment with the details of the filter you want to apply, the more specific, the better. I’ll try my best to help you.
If this doesn’t apply to your case, please capture a screenshot of the error.
If possible, please share the file so I can get better insight. If you're concerned about privacy, just comment and I’ll send you a private message with instructions on how to send the file securely.
Looking forward to helping you further!
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hi Gabriel; Just got the time to get back to this, the link you provided does describe the issue to a "T". Can't get a screen capture because the capture software menus block those particular Access pull-downs. The version of Access I am using is whatever version comes with a current "lease subscription" to MS Office#65. Don't know VBA. but thanks; <<removed PII>>
Hi Dave
Thank you for reply! I’m glad the link described your issue accurately.
Since screenshots aren’t possible and VBA isn’t an option, if you’re comfortable, could you share a copy of the Access file (you can remove or anonymize any sensitive data)? This will give me better insight into the structure and help me suggest a query-based solution for your report.
If privacy is a concern, let me know and I’ll send you a private message with instructions on how to share the file securely.
Looking forward to your reply.
Please note that our forum is a public platform, and we will modify your question to hide your personal information in the description. Kindly ensure that you hide any personal or organizational information the next time you post an error or other details to protect personal data.
![](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(80, 18%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAH%3C/text%3E%3C/svg%3E)
Hi Dave,
I hope you’ve been doing well.
I just wanted to check in to see if you’ve had a chance to review Gabriel’s reply yet. I understand things can get pretty busy, so no rush at all, I just wanted to make sure it didn’t slip through the cracks.
If there’s anything you need, please don’t hesitate to reach out. I’d be happy to assist in any way I can.
Can you provide a repo database for review?
If so, remove any sensitive or personally identifying information and upload it to a sharing site (OneDrive, DropBox, etc.)
Also, we need to know the version and build of Access you are using.
Thank you.
What is meant by "Repo"?
The problem has been 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
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.