Replacing MS Access built in Error Messages

[DRH192]

All,

Is it possible to replace the following Access message with something more human. Or even better for no message box to appear at all.

"The field <My Field Name> cannot contain a null value because the required property for this field is set to true. Enter a valid value in this field.

Cheers

 

[MajP]

You should validate the field in the forms before update event. Then provide your message and then cancel the event if the data is not valid.

http://msdn.microsoft.com/en-us/library/bb238523.aspx

or google "cancel beforeupdate access" for more examples

 

[DRH192]

yep, much better solution.

many thanks