Clearing a Date field

[chris.williams]

I am having some difficulty clearing a date field.



The form issue a "certificate" and the date the certificate was issued. I have a button on the form to clear a certificate if issued in error.

I am attempting to clear the date field through

[CertDate] =""

but am unable to due to the date type not accepting a null value. The error I get is:

"You tried to assign the Null value to a variable that is not a Variant data type."

Any help is appreciated...

Thx

[June7]

The "" is not a null, it is empty (zero length) string. Date/time data type field cannot have empty string. Don't know why the error message references null. Maybe that's just the best message statement Access can offer for the error.

Try:

[CertDate] = Null

[chris.williams]

Thank you. Tried that already. Didn't work for some reason. I got the same error.

[June7]

Then don't know why having issue.

Is CertDate also name of textbox on the form?

I give bound controls a name different from field name. Often I refer to the control name instead of field name. Example from my code: Me.tbxDateEnter = Null

[chris.williams]

It was, I changed the text box to have a different name than the field. Unfortunately, I get the same error.

[June7]

Since can't replicate the issue, will have to anlayse your db and code. If you want to provide, follow instructions at bottom of my post.

[chris.williams]

The data is in a MySQL db, not in Access - do you still have the resources to receive and diagnose it?

[June7]

Sorry, no I do not have any flavor of SQL. So the problem is with MySQL, not Access?

[chris.williams]

While I have yet to confirm the issue is resolved, I believe the you led me to the answer. Those fields were marked as NN or Not Null in the db. I changed them and was able to manually clear the fields, but have yet to test the functionality from the Access app. Thank you