Make date null or blank

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am a newbie. I am also about to pull my hair out. I have a form that has
two checkboxes(Posted and Pending) and a date field (Posted Date). When
Posted is checked the user is required to put in a Posted Date. If they make
a mistake and check Pending, I want the date field to clear. Here is the
code I've tried:

If pending.value = true then posteddate.value = " "
If pending.value = true then isnull(posteddate)

I have tried using " ", null and 0 for the Posted Date value and still
cannot get it to clear the date value. Can someone please help? I've
searched Visual Basic help and Access help and cannot find out how to do this.
 
This is correct:
If pending.value = true then posteddate.value = null

Actually, the .value bits are unnecessary, because Value is the default
property of an editable control.

You say you already tried =Null. What was the error or unexpected
behaviour?
 
Back
Top