Can I change an Error Message to direct user to correct field

[bruce24444]

I have a field in a table set to "Required". When a user is inputting data via a form and if they leave this field blank, Access automatically returns the following error message:

The field ‘tbl:Main.ClaimNumber’ can’t contain a Null value because the required property for this field is set to True. Enter a value in this field.

Can I change this message to say something different as the database is going to be used by many people and not all of them would know what the error message is asking them for?

[FishVal]

Hi, Bruce.

Before Access shows the message Form_Error event is being triggered. You may write where a code showing custom message and change Access default behavior by setting the event argument value before exiting the sub.

Regards,
Fish

[missinglinq]

Here's an example:

Private Sub Form_Error(DataErr As Integer, Response As Integer)
Dim Message As String
If DataErr = 3314 Then 'Field is required and can't be NULL
Message = "Your Custom Message Goes Here"
Response = MsgBox(Message, vbExclamation, "This Field Must Contain Data!")
Response = acDataErrContinue
End If
End Sub

Welcome to TheScripts, Bruce!

Linq ;0)>