Urgent1

[David Smith]

I am using a Text Box - Format property set to

Medium Date. Now whenever I enter invalid date and as soon as I came out

from text box, Standard Error Message of MS-Access pops up and asks for a

valid date.



I am checking all the validation but Standard Message displays before the

execution of manual error handing procedure.

Plz guide me how to solve this problem. Its really very urgent.

 

[Ken Snell]

You could trap this using OnError event of the form...but you can't do this
in a macro, you must use VBA code.

Private Sub Form_Error(DataErr As Integer, Response As Integer)
Response = acDataErrContinue
End Sub

This code will suppress the display of the standard error message, and you
then can use your own.