Capture Input Mask Error before Access does? (1 Viewer)

darbid · Jan 12, 2009

My problem is that I do not like the error message Access uses when someone does not follow the input mask.

I realise that I need to caputre the error by getting the error number.

But what is the sub or event that I should put this in?

gemma-the-husky · Jan 12, 2009

might be the forms onerror routine

try seeing if an input mask error calls the forms error routine. Then you can intercept that error code, and provide your own message

darbid · Jan 12, 2009

gemma-the-husky said:
might be the forms onerror routine

Thanks GTH you got it.
So for anyone that has got here what I have done is put the following in the forms on error event.

I want to avoid the standard Input Mask error message. The main reason is that if someone does not enter it correctly access shows the actual input mask which even I do not understand.

I am not sure if I have got the err number right but I get a number of 2279.

Code:

Private Sub Form_Error(DataErr As Integer, Response As Integer)
    If DataErr = 2279 Then
        Beep
        MsgBox "Your message goes here", vbCritical, "Idiot Proofing"
        Response = acDataErrContinue 'this stops the access message
        Exit Sub
    End If
End Sub

Capture Input Mask Error before Access does? (1 Viewer)

darbid

Registered User.

gemma-the-husky

Super Moderator

darbid

Registered User.

Similar threads

Users who are viewing this thread