Input Masks

[Russell Farr]

Hi

I have an input mask set up on a text box, but the message
that comes up when you haven't entered everything into the
field isn't very user friendly.

Is there a way of customising that message so I can get
the database to explain exactly what is required? I tried
putting in validation text but it needs a validation rule
to work and doesn't seem to look at the input mask.

For your information, I'm needing people to enter in an ID
number in the form AB123456C so I created the input mask
LL000000L.

Any help would be appreciated.

Thanks

Russell

 

[Wayne Morgan]

In the OnError event of the form, check for error # 2279 using the DataErr parameter. To
cancel the automatic message set Response = acDataErrContinue.

Example:
If DataErr = 2279 Then
msgbox ("My error message")
'do what you want here to fix the problem
Response = acDataErrContinue
End If

 

[Myron]

Is it a Required Field? Or is it the Primary Key?
What you could do is on the after update event or lost
focus event, is put some code in there to check if any
data has been entered and to be sure that the user goes
there you can set the focus to that control on form on
open event. I couldn't mine to do what yours it. What
was the error message>?

 

[Russell Farr]

Thanks for this Wayne - it works perfectly.

Russell

-----Original Message-----
In the OnError event of the form, check for error # 2279

using the DataErr parameter. To