get rid of error msg when inputmask i set

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jesper F - 18 Jan 2005 23:31 GMT

I have a field with an input mask like 000000-0000
If the user enters 0 or alle characters input is accepted but if any number
of characters in between 0 and 10 is entered it raises the error: "The value
you entered isn't appropriate for the input mask...".

Is there a way to have the input mask but not get the error if the user
leaves the field?

Reply to this Message

Wayne Morgan - 19 Jan 2005 01:51 GMT

The requirement of "0" is:
Digit (0 to 9, entry required, plus [+] and minus [-] signs not allowed).

If you use 9, the requirement is:
Digit or space (entry not required, plus and minus signs not allowed).
(From the Help file)

Place the cursor in the Input Mask box and press the F1 key. You will get
information on what the different input mask characters do.

Signature

Wayne Morgan
MS Access MVP

>I have a field with an input mask like 000000-0000
> If the user enters 0 or alle characters input is accepted but if any
[quoted text clipped - 5 lines]
> Is there a way to have the input mask but not get the error if the user
> leaves the field?

Reply to this Message

Jesper F - 19 Jan 2005 10:59 GMT

> The requirement of "0" is:
> Digit (0 to 9, entry required, plus [+] and minus [-] signs not allowed).
[quoted text clipped - 5 lines]
> Place the cursor in the Input Mask box and press the F1 key. You will get
> information on what the different input mask characters do.

Yes off course. Thanks.

Reply to this Message