It seems that if the length of the entry in the field is greater than 10
characters you want to cancel the entry. Why not just limit the field size
to 10 characters? Anyhow, if you want to remove the entry you need to add:
Me.txtMasterField.Undo
Anatoly Kurilin wrote:
To make the investigation easier, I've changed the code but of no avail ...
Private Sub txtMasterField_BeforeUpdate(Cancel As Integer)
If Len(txtMasterField.Value) 10 Then
Beep
Cancel = True
End If
End Sub
OK, what is gCustomerInitials? Seems to be a user-defined function, but
what
[quoted text clipped - 18 lines]
http://www.esetnod32.ru/.ml
__________ Information from ESET NOD32 Antivirus, version of virus signature database 5115 (20100514) __________
The message was checked by ESET NOD32 Antivirus.
http://www.esetnod32.ru/.ml
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201005/1