[AccessD] Re: Intercept a date format error - RESOLVED

Hi Joshua,

You are a legend! 
That fixed it straight away. Thank you for your help.

Cheers 
David Ô¿Ô¬ 
Brisbane Australia 


Your reply......
Date: Tue, 26 Aug 2003 16:16:47 +1000
From: "Joshua B" <lists at jbsolutions.com.au>
Subject: Re: [AccessD] Intercept a date format error
To: Access Developers discussion and problem solving
Content-Type: text/plain;      charset="us-ascii"

Hi  David:

That error actually needs to be trapped at the form level, something like this...

Private Sub Form_Error(DataErr As Integer, Response As Integer)
	Select Case DataErr
    		Case 2113
        		MsgBox "Wrong date format!"
        		Response = acDataErrContinue
	End Select
End Sub