Capturing error when using and edit mask

[hpl2001]

Hi:

I have an access program that uses edit masks for some data field in my input forms. I want to capture the event when a user tries to make an entry that does not match the mask - i.e. I want to customize the error message that access is generating. Can anyone tell me how to capture this particular error?

TIA.

Holly

 

[lameid]

I don't think you can.

However you could use the afterupdate event to replicate the behavior of an input mask (look at the oldvalue property for when you want to set it back) and do any custom logging in the afterupdate event.

 

[dhookom]

I think the error can be trapped in the Form error events.

Duane
Hook'D on Access
MS Access MVP

 

[missinglinq]

Duane's correct here, as usual.

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

Select Case DataErr
 Case 2279
  MsgBox "your error message goes here"
  Response = acDataErrContinue
 Case Else
  MsgBox Err.Number & "   " & Err.Description
End Select

Response = acDataErrContinue

End Sub

Just replace my message with your own.


The Missinglinq

Richmond, Virginia

The Devil's in the Details!