Data type conversion error--Please help

[testermans]

I have created a VB Project to include data-entry forms for a MS Access database. Since I added the field (Last Updated), I am getting a data-type conversion error whenever I try to add records to my table. The table in the Access db is defined as a date/time field with an Input mask for the Short Date. Could this be causing my error??

[Ludmila]

I had this problem with date/time conversion
error. But I used Crescent activeX control for date/time field. To solve this problem I unbounded control, because if it's empty it's not valid format for date/time field(So you can not save data).

Try using CDate before you save the field.



------------------

Vincent van den Braken
EMail: azzmodan@azzmodan.demon.nl
ICQ: 15440110 (http://www.icq.com/15440110)
Homepage: http://www.azzmodan.demon.nl