setting a date value to null from a checkbox

D

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top