how do I 'blank' a date field

K

Karen

I have a button on a form that blanks out several fields. For text fields
I'm using [fldname]=empty. That works okay. If I use [flddatefld]=empty I
end up with a date of 12/30/1899. What is the expression I should use to
blank out a date field?

Karen
 
A

Allen Browne

Try:
fldname = Null

Empty is a special value that is assigned to a Variant before you assign any
other value. You want Null - the value of a field that has no entry.
 
Top