cSqlInsert = "insert into Company ( MYDATEFLD ) values " + ; >> "(" + IIF(lfdate="NULL",[NULL],[']+lfdate+[']) + ")">
lfdate = NULL && note no quotation marks! cSqlInsert = "insert into Company ( MYDATEFLD ) values " + ; "(?lfdate)"This should work if the lfdate contains a NULL value or a date value.