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




"BruceM via AccessMonster.com" u54429@uwe wrote in message
news:a800b4b0d9340@uwe...
OK, what is gCustomerInitials? Seems to be a user-defined function, but
what
is its code?

Anatoly Kurilin wrote:
Private Sub txtMasterField_BeforeUpdate(Cancel As Integer)
If gCustomerInitials(txtMasterField.Value, True) = "" Then
Cancel = True
End If
End Sub

What code is in the control's Before Update event?

[quoted text clipped - 12 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