Personalising Input Mask Error Messages

[marystewart78]

Hi All,

I've put an input mask into a table and would like to personalise the error message to give the user more information about how they should be entering the data correctly. I don't know where to start with this - can someone point me in the right direction??

Many Thanks,

Mary

 

[reclusivemonkey]

I don't think you can customise the error message from a InputMask. Can you use the validation rule and validation text options from your table?

 

[Jack Skeleton]

Hello,
I've never tried to do something like this using the ValidationRule/ValidationText way. It's easier to create a validation macro an associate it to the afterupdate event.
For instance:

If isnumeric(me.yourfield.value) =false then
msgbox "No, no, nooooo....", vbokonly+vbinformation, "WRONG INPUT"
end if

That's basic, you can complicate it as much as you want (different error messages depending on a selected case, clearing the field & setting the focus again after the message....)

Hoping that helps...

 

[Jack Skeleton]

Hi again,
Just a tip that could help:

The error code for breaking a validation rule is 2279. You can catch it with an "on error" event in your form (if err.code = 2279 then... else...)