Assign empty string to a value

[dealwi8me]

I have this code:
If Me.XIII3 = True Then
Me.XIII3Notes = ""
End If

where XIII3 is a checkbox and i want it when it is checked to get an empty string at XIII3Notes, but it doesn't work...

any suggestions?

(I call the code on Current event)

 

[Bat17]

If you want it to do it when clicked then do it on the checkbox's onclick event.

Peter

 

[Mile-O]

If Me.XIII3 = True Then
Me.XIII3Notes = ""
End If

Private Sub MyCheckBox_AfterUpdate()
    If Me.XIII3 Then
        Me.XIII3Notes = vbNullString
    End If
End Sub

Personally, I'd set it to Null, rather than vbNullString though.

 

[dealwi8me]

Personally, I'd set it to Null, rather than vbNullString though.

Tnx! That works