Null Variable Assistance

[jstevens]

I'm having a challenge with an If/Then statement relative to a "NULL".

I can't get the code to identify the "NULL" and process the "IF". I have tried = "", = "NULL" and = NULL.

untitled.png

Regards,
John

[HansV]

Use the IsNull function:

If IsNull(objRecordset.Fields(ReturnField)) Then

[jstevens]

Thank you Hans,
John