Testing for a null field in a recordset in vba

S

Simon Guertin

Hi, I am having a hard time to test if my field that could
contain a date is null or not.
IsNull does not seems to work
is not null.. I don't know what to do.

here is some of my code:

IIf(Not IsNull(destination.Fields(1).value).....


is this the proper way to test a field to know if it is
null?

thanks

Simon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculations with possible null value fields 1
Test for empty field in a DAO Recordset 6
VBA Export to PDF 0
Null is my enemy.... 5
VBA ADODB Automation - Truncated Memo Fields 3
>> adodb.parameter to handle nulls 2
Select from a table in an IF statement 3
Testing for null 4

Top