Can I change the text for the required property warning?

[Andy Sauer]

Hello. I have a database in Access 2002.

I have a table where the field "Name" is set as a required field.

I have a form that populates that table. When somebody forgets to fill in the Name and they attempt to proceed forward, they receive this message:

"The field 'Name' cannot contain a Null value because the required property for this field is set to True. Enter a value in this field."

Can I change the text of this message? I would like to change it to be a little more user friendly.

I know I can use the code below to write my own message. However, I have found people are still able to move ahead without filling in name by clicking on the little forward arrow at the bottom of the form or by using the mouse wheel. I'm not sure why they do this...but they sometimes do. By making the field required in the table itself, people cannot proceed without filling in Name no matter what. So, my ideal would be to change the default message itself. Thanks for your time and ideas.

I have tried this, but people can still bypass it:

Private Sub Save_Record_Button_Click()
On Error GoTo Err_Save_Record_Button_Click
 
If IsNull(Me![Name]) Then
  MsgBox "You need to input a Name in order to proceed", vbCritical, _
         "Missing Required Data"
           Exit Sub

[Andy Sauer]

Great article at:

http://bytes.com/topic/visual-basic/...essages-access

The only thing is I had to make a slight change in the code. The code I used was:

Private Sub Form_Error(DataErr As Integer, Response As Integer)
If DataErr = 3314 Then
    MsgBox "You are missing a Name."
    Response = acDataErrContinue
Else
    MsgBox "Error No.:" & DataErr
End If
End Sub

Error 3314 was the original message, and I am replacing it with my own message. I found out 3314 was the error number by clicking on the Help button when the error appeared. In the Help window, it states the error number.

As the article states, you can use this code to change any error. Thanks to hyperpau for the great information.