Clear Single field?

[rodvaN]

Whats the command to clear current field when adding AfterUpdate() and BeforeUpdate() ?
Im using something like this but not working.

Private Sub Data1_AfterUpdate()
If Data1 = LCase(Data1) Then
    MsgBox "You have to use CAPS"
    Me.Field = Null
    Me.SetFocus
    Else
    Resume
End If
    
End Sub

 

[rodvaN]

Ok..
I figured it out
It was simple

Field = Null

This may work for newbies like me out there googleing.

 

[SOS]

Actually you should check in the BEFORE UPDATE event instead of the AFTER UPDATE event because then you can just cancel the update.