Problems importing from empty date/time field in word form 1

[alexkeel79]

Hello all,

I'm new to Access DB modules so I'm not sure what is going on. I created a module that imported data from a word form. Everything works fine except when importing date/time information. If the field in the table is type date/time and the field in the form is null then I get the following error "Access DB error -2137352571: Type Mismatch". If the field in the form is filled in with a properly formatted date the import works fine. Also if I change the data type of the field in Access to Text the import works fine. Does anybody know how to fix the code so that if the date/time field in the form is blank then the module would just import null into the table for the date/time field? Here is the line of code from the module:

!expDt = doc.FormFields("expDt").Result

 

[PHV]

!expDt = IIf(IsDate(doc.FormFields("expDt").Result), doc.FormFields("expDt").Result, Null)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[alexkeel79]

That worked. Thank you very much. You get a star.