Date Fields and Access Databases

[Mike]

I have a form that writes to an Access dbase. It contains multiple date
fields. Of these date fields, none, one or even all of them could be filled
in.

I need to have the Data Type, in the dbase, set to Date/Time for formatting.
I have the fields set to NOT be required. (I cannot have the Data Type be
text.)

My problem is that if any of the Date fiels are left blank then I get a
'datatype mismatch error' when writing to the dbase. I am assuming that the
dbase cannot record a blank field as a date type.

But what I do not understand is that if I were to add a record to the dbase
from within Access it will allow the date fields to be left blank.

How can I have the form write to the dbase even if a date field is left
blank?

Thanks for your help,

Mike

 

[MD WebsUnlimited.com]

Hi,

I've assumed that you're using the DIW to populate the database and as such
each field requires a value or a default value.
See the following:
http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp