Change Msgbox when field is required

[Duffymk]

Hello -

I have a field called 'Date' which has been set to Required in the table settings. I also have a data-entry form used to populate this table. If the user tries to move to the next record while leaving 'Date' null, the usual message box pops up telling them they must enter a value. Is there a way to customise this message box?

Thanks! MD

 

[jgoodman00]

Yup, you need to add some code in the forms error event:

Private Sub Form_Error(DataErr As Integer, Response As Integer)

If DataErr = 3314 Then
MsgBox "Custom message here!"
Response = acDataErrContinue
End If

End Sub


Err.Number 3314 is the error message you are wanting to trap AFAIK

James Goodman MCSE, MCDBA

http://www.angelfire.com/sports/f1pictures