As a matter of fact, I limited the length of the entry as an example of any
cancelled action. And I don't want to remove the entry - user has to see
what he/she entered. All I want is to make the control to behave in a proper
way - there mustn't be any way to bypass the command Cancel = True.

"BruceM via AccessMonster.com" u54429@uwe wrote in message
news:a801471a84590@uwe...
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


__________ 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






__________ 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