setting a date value to null from a checkbox

[Derek Davlut]

Hello People,

I was wondering how to set a date value to null from a checkbox in a form?
The date value field name is dateactual70. Is this possible or is there
another way to do this? The checkbox is dateactual70cond.

Currently I have tried.
IIF([dateactual70cond]=1,[dateactual70]=#1/1/4501#,[dateactual])

Thanks for your help.

Derek.

 

[Sue Mosher [MVP-Outlook]]

I'm lost. What are dateactual70cond and dateactual?

In any case, a formula field may not be the way you want to go, unless you
always want to set the field with a formula.