<div>
Hi,<br />
<br />
Beware that the type convertion function don't accept null value.<br />
Plus manipulating memo fields with strings can lead to unexpected behaviors, such as the result beeing shrunk to 255 characters.<br />
<br />
Did you try this ?<br />
[MemoField] IS NULL
</div>


<div>
<blockquote>
memo field
</blockquote>
Do you mean &quot;Long Text&quot;?<br />
<br />
Why is cstr() needed?<br />
The query should work well without it...:<br />
<br />
SELECT Field1, MemoField<br />
FROM YourTable<br />
Where MemoField IS Null<br />
<br />
Am I missing Something?<br />
<br />
JeffCoachman
</div>


<div>
FWIW, &nbsp;...I could only test this in Access 2013.<br />
Another Expert will have to confirm what we posted for Access 2016, ..to be sure...
</div>


<div>
have you tried <b>NZ </b>function?<br />
<br />
Nz Function<br />
<a href="https://support.office.com/en-us/article/Nz-Function-8ef85549-cc9c-438b-860a-7fd9f4c69b6c" rel="ugc">https://support.office.com/en-us/article/Nz-Function-8ef85549-cc9c-438b-860a-7fd9f4c69b6c</a><br />
<br />
but what is actually you want to achieve here?
</div>


<div>
Solution posted, no activity from OP
</div>


<div>
<div class="content wysiwyg-content">
Using Access 2016 and the query says it fails. &nbsp;I tried the function of Cstr([MemoField]) with &quot;Is Null&quot; for the criteria and still no luck. &nbsp;Any suggestions?<br />
Thanks, Kevin
</div>
</div>


Using Access 2016 and the query says it fails.  I tried the function of Cstr([MemoField]) with "Is Null" for the criteria and still no luck.  Any suggestions?
Thanks, Kevin

Trying to get results from a query where the criteria for a memo field is set to &quot;Is Null&quot; and it doesn't work...

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Trying to get results from a query where the criteria for a memo field is set to &quot;Is Null&quot; and it doesn't work...

Trying to get results from a query where the criteria for a memo field is set to "Is Null" and it doesn't work...