how to import blank dates in word form to access

[steed800]

Hi,

I managed to create a visual basic module in access that will import form
fields from a protected word form into access. When all of the fields are
filled out, it imports fine. The only problem I'm having is that there are
several date fields in the form and if any of them are left blank I get a
type mismatch error and can't import anything.

How can I get access to recognize a date field is blank and skip over it or
enter "null" for the value?


Thanks!

 

[Jeanette Cunningham]

How are you doing the import?
Are you saving the data from the word form as a text file and importing
that?
Are you using vba to import one field at a time?
Is there any way to modify your code to use the Nz function to cope with
null values?

Jeanette Cunningham