beforeupdate event (97)

[andrewgibsonsw]

I have a text box control called txtSalary and want to check the amount and cancel it if it is greater than

[Francois]

You can use the following code :
<pre>Private Sub txtSalary_BeforeUpdate(Cancel As Integer)
If Me.Text0 > 50000 Then
SendKeys "{esc}"
Cancel = True
End If
End Sub</pre>

[HansV]

Instead of <font face="Georgia">SendKeys "{Esc}"</font face=georgia>, one can also use

<font face="Georgia">txtSalary.Undo</font face=georgia>

This has the same effect (undoing changes to the control).