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?
 

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

Similar Threads

Checking Date for Null 14
set DateTimePicker value to null issue 1
Function problems 9
sorting: cleared/null v/s "" 3
Date stamp on exit 4
reset a date field to null 2
Invalid use if 'Null' on date field. Date field intentionally left blank 2
Date Validation Current Date / Past 45 Days / Null OK 2

Back
Top