[AccessD] = NULL

How about trying this:

If IsNull(txtStartDate.Value) = TRUE Then
	MsgBox "Please fill in the required dates", , "dates missing"
	exit Sub
End If

Ken Stoker
Technology Commercialization
Information Systems Administrator
PH: (509) 375-3758
FAX: (509) 375-6731
E-mail:  Kenneth.Stoker at pnl.gov 


-----Original Message-----
From: Oleg_123 at xuppa.com [mailto:Oleg_123 at xuppa.com] 
Sent: Friday, February 06, 2004 12:50 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] = NULL


I know i am not suppose to write = Null, but is null doesn't work
either, whats the correct coding ?

If txtStartDate.Value = NULL Then
    MsgBox "Please fill in the required dates", , "dates missing"
    Exit Sub
End If



-----------------------------------------
Get Breaking News from CNN, ABC, NBC, CBS Now.
http://www.xuppa.com/news/?link=webmail


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com