I commonly do this, you should be able to use 

rs("date") = null

Make sure the access field is set to "Required = False"


Is this what you are doing?

if you use
rs("date") = empty
you get a date something like 30-dec-1970

hope this helps,
Phil.

> -----Original Message-----
> From: Fredrick J. Krantz [mailto:krunch97@m...]
> Sent: 22 May 2000 20:54
> To: professional vb
> Subject: [pro_vb] null problem
> 
> 
> Does anyone have a fix for null problem with an access 
> database field.  
> Problem is i am trying to delete a date and it will not let 
> me update the 
> field after clearing the field from a date to no date.  Is 
> this possible or 
> should i work around this problem.
>