I have a column in my access database with the name ABCD. The format of the column is set to short date format. I have a textbox in my excel userform where I would sometimes write the date in the textbox and other times leave it empty.
The code works fine if a date is written in the textbox. but if the textbox is empty i get the error "Type Mismatch" highlighting the line
Code: Select all
.Fields("ABCD") = Me.txtMyDate.Value