how do I 'blank' a date field

[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

 

[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.

 

[Roger Carlson]

Try using Null instead for BOTH cases.