Urgent1

  • Thread starter Thread starter David Smith
  • Start date Start date
D

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.
 
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.
 
Back
Top