Simple null/not null question.

[Atomsk]

Dim a
If [Required date].value <> NULL Then
MsgBox &quot;Is not NULL&quot;
Else
Text1.value = [Required date].value

End If


The value should NOT be null, but the &quot;Is not null&quot; box never pops up. Rather, the value of the [Required date] field is displayed in Text1. The values are being displayed, so they are obviously not NULL. [Required date] is a date/time field. Any ideas? Thanks a lot.

 

[Atomsk]

This is in Access 2000, btw.

 

[AntiEarnie]

I had something like this pop up a while back. Try just using &quot;&quot; instead of the NULL.

 

[Atomsk]

Got it. Thanks.