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

To work around it, use an Update query.

Answer 2

Hi MarkConrad,

Thanks for posting your experience with us.

If you received a community reply notification email about calling “Microsoft Support”, please do not call the number due to privacy concern, it is a spam. We have deleted the spam and report it.

According to your description, it seems that FIND AND REPLACE "is null" doesn't work in Access. So I test it on Access version 2008 based on your screenshot data, and I can reproduce it that get the same behavior as yours.

Sorry for the inconvenience caused at your end, considering we also have the same problem, it might be a bug we think, so to further help you, we sincerely recommend you go to Access Feedback and let the related team aware this, we will also help report this to the team. You can go to Access> click Feedback> I Like Something.

We appreciate your understanding and cooperation again.😊

Wish you a nice day!

Best regards,

Gloria

Answer 3

Hi,

I cannot reproduce this problem, when I try it, it successfully replaces the null fields with WAS BLANK.

Can you provide the information from the 'About Access' box after you click File/Account?  It should look something like this:

Thank you,

Shane Groff

Access Engineering