Date fields and null values

Originally posted by : Paul (willmanp@akrr.com)Here's the problem I'm currently grappling with - hopefully, someone out there has dealt with this in the past. I've got my little database with some date fields in it. Every now and then, the situation arises where I want to erase the data in the date field, but if I try to save a zero-length string, I get a Type Mismatch error. One way to handle it would be to just have a second field that I use to say whether or not to treat the field as empty, but I don't want to have to do it this way.Any thoughts?Thanks in advance,Paul

Originally posted by : PaulNeeevermiiiiiiind - just figured it out....tVar = NULLRS("DateField") = tVar...------------Paul at 10/11/2001 1:13:30 PMHere's the problem I'm currently grappling with - hopefully, someone out there has dealt with this in the past. I've got my little database with some date fields in it. Every now and then, the situation arises where I want to erase the data in the date field, but if I try to save a zero-length string, I get a Type Mismatch error. One way to handle it would be to just have a second field that I use to say whether or not to treat the field as empty, but I don't want to have to do it this way.Any thoughts?Thanks in advance,Paul