In Access, FIND AND REPLACE "is null" doesn't work.

Question

Brand new install of Office 365 on brand new desktop.

In Access, FIND AND REPLACE "is null" doesn't work.   "Find next" button works, but then both "Replace" and "Replace All" buttons return "search item not found."  Screen shot shows a brand new test data base to show this.  FIND "is null" successfully moved to the next empty field.  Then clicking on "Replace" or "Replace All" returns "Not Found".    All this is a change from what worked in previous Access. 

I saw this problem on this forum from February 2020 but it remained unresolved.

Answer 1

What is the data type of the field in question?

Short Text may be working differently than Long Text.

Answer 2

Here's my Access for the test db that doesn't find "is null".  The field is SHORT TEXT.

Answer 3

Same error when fields are LONG TEXT.

Answer 4

Thanks Mark. We have a reproducible scenario. It's now on the backlog.

Thank you for reporting it!

Answer 5

I checked previous versions, and although this came close to working properly in Access 2010, I would say it has never been without issue.

For example, in 2010, doing a Replace All with 'is null' will replace both nulls, and zero-length strings, which is not correct behavior.

Shane Groff

Access Engineering