Fix Bug in Datasheet Quick (dropdown) filter
There is a bug if you want to filter for text that contains "+" or "&", see
There are other bugs: If you try to filter for
Equals "in Progress"
or any text that starts with "in ", you get the message "Enter a valid value".
If you try to filter for something that starts with "not ", e.g.
Equals "Not started",
you will get wrong results because the filter then reads like:
There are probably more. All of this comes from the fact that the input to the text filters is obviously not properly quoted when the filter expression is constructed. Should be easy to fix!
The bugs are still present in Access 2016.
Thanks for reporting.
We will add this bug report to our backlog and see that it is prioritized and handled.
In the meantime, I’m updating the status for ‘No Current Plan’ so that you use your votes again.
Matthias Kläy commented
This bug seems to have been fixed in recent versions of Access 2016 (November 2017).
It would be nice if you could publish this here.
Kläy Computing AG