Clear Date

[callumwatson]

How can I clear the contents of a field?

This is my code so far but I need to set clear the Target date field when the checkbox is not ticked : -

Private Sub Completed_AfterUpdate()

If Me!Completed = True Then
Target_Date = Date
Else
'Want to clear Target_Date here
MsgBox "No date"
End If

Callum

End Sub

 

[kalicinski]

could try
target_date = null

 

[callumwatson]

That worked - should have known or at least guessed that!!

Thanks