Designate Empty Field?

  • Thread starter Thread starter depawl
  • Start date Start date
D

depawl

I need to specify a date field (MyDate) to be empty if certain
conditions in my form are met:

If <Conditions Met> Then
Me.MyDate.Value = Empty (or Contains No Data or IsNull)

I don't seem to be able to get it to work.
Thanksl
 
Hi,

I think you could probably use the Form's Current event for this.

Something like:

Private Sub Form_Current()
If <Conditions Met> Then
Me.MyDate.Value = Null
End If
End Sub

Or maybe:

Private Sub Form_Current()
If <Conditions Met> Then
Me.MyDate.Value = ""
End If
End Sub

Hope that helps,
Jeff Conrad
Bend, Oregon
 
You want:

me.mydate.value = null

though I personally would code that as:

me![mydate] = null

HTH,
TC
 
Back
Top