If you want to validate field values you should use the form's Before Update
event. If the user does not make an entry in a control, the Before Update
event for that control will not run, and a required value will not be checked.
However, the form's Before Update event checks for values in any fields you
choose.

If you are talking about a control's Before Update event, the code as you
entered it Beep and Cancel will result in a beep only if the user has the
sound turned on. Cancel will cancel the update, but will not do anything to
the field value. However, it will not let you leave the control without
updating IF you updated the value by typing into the control (rather than by
code).

I cannot find a way to bypass the Cancel = True, but I suggest you add a line
of code:
Debug.Print "Before Update test" or
MsgBox "Before Update Test"
in the control's Before Update event to be sure it is running.

Anatoly Kurilin wrote:
No, it does not!

So you're saying that in your most recent example if the user makes an
entry
[quoted text clipped - 19 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