IsNull Function

  • Thread starter Thread starter Cameron Piper
  • Start date Start date
C

Cameron Piper

Can someone please help with the code below. I am trying
to not allow someone to recomplete an activity by
clicking the complete activity. By doing so the user
would redfine the completion date as now(). I know there
is no such thing as an IsNotNull function but how would I
accomplish the same thing. DateComplete is a text box
and I am trying to say that if there is a date in that
box, call this Message Box.

If IsNotNull(Me!DateComplete) Then
MsgBox "This activity has already been completed." _
& vbCrLf & vbCrLf & "To view the completion notes.
Click" _
& vbCrLf & "the open completion notes above",
vbInformation, "Previously Completed"
Exit Sub
 
Actually there kind of is such a thing...

If Not IsNull(Me!DateComplete) Then

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 
Back
Top