input mask for controls

R

rocco

Hello,
i have decided an input mask for a text box. The input
mask is 00\-00\-00\-00;0;_
I have also setted the max size for the field to 11
characters.
Now i have also written code to drive the user whenever
he leaves the control having inserted less then 11
characters. This code (i think) should be driven by the
BeforeUpdate event. But I'm not able to avoid the default
message from access saying that "the value you entered
isn't appropriate for the input mask... specified for the
field". It seems to me that this msg is driven by some
other event that happens before the BeforeUpdate (i have
tested it using the changing in the caption of al label),
but which event??!!
How can i avoid any messages from access?
Thanks anyone can help.
 
D

Dan Artuso

Hi,
The error is from the form's OnError event and the number is 2279.
You can trap this error and display a custom message if you want,
but I don't think you'll be able to set the focus to another control
while the data is invalid.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating Custom MS-Access Input Masks -- Where can I find the codes to use? 0
Time format hh:nn drops leading zero 0
Formatting dates in text field 9
input mask for phone number 2
Data validation for input of date in the form of dd/mm/yyyy 1
Old data format to new format - Not compatible with old Input Mask 2
Custom, Automated Input Masks 2
Question on Input Masks 1

Top