Problem with field containing null value

[wjoc1]

Hi I have an If statement checking the value in a particular field. The format for the field shoulld be a date but if it is not filled in I assumed it would be null.( I have no other default value specified for the filed) Why isn't this piece of code working?

If ([Forms]![SCHEMEJOBS-NoLineJOB]![COMPLETED DATE] = Null) Then
<some_statements>
End If

Can someone please help?
Thanks,
Liam

 

[charityg]

Try this instead:

If (IsNull([Forms]![SCHEMEJOBS-NoLineJOB]![COMPLETED DATE]))or ([Forms]![SCHEMEJOBS-NoLineJOB]![COMPLETED DATE]="") Then
<some_statements>
End If

 

[Jacob Mathai]

If IsNull([Forms]![SCHEMEJOBS-NoLineJOB]![COMPLETED DATE] ) Then
<some_statements>
End If