I want to duplicate a record and then blank out a date field in it. I found the duplicate record option in the command buttons, but if I try to set the field to blank, it gives an error; setting it to 0 gave me 12/31/1899. Date(0,0,0) does not work either. Even though I don't know much VBA, I tried creating a date field hoping that the default value would be blank, but it kept the date instead of replacing it.

have you tried setting the datefield=null?

THANK YOU! I did not know that you could do that, but it worked like a charm!