Substitude a error message with a MsgBox

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

erick-flores - 07 Dec 2006 21:55 GMT

Hello all

I am trying to make this 'error' message go away and display my own
MsgBox. I have set some of the fields in one of my tables to Required.
And when I am actually interacting in the form and i dont fill that
required field it popsup this 'error' message saying "The field 'xxx'
cannot contain a Null value because the Required property for..." I
want this message to be substitude by my on MsgBox. How do I do that?

Thanks in advance

Reply to this Message

Van T. Dinh - 08 Dec 2006 03:41 GMT

Generally, you should use code in the Form_BeforeUpdate Event to perform all
data validation before actually trying to save the Record.

Check Access VB Help on the BeforeUpdate Event of the Form object. There is
a sample code in Help also.

Signature

HTH
Van T. Dinh
MVP (Access)

> Hello all
>
[quoted text clipped - 6 lines]
>
> Thanks in advance

Reply to this Message