Validation Rule for IBAN Account number in MS Access Form field

G

Guest

Hi,

In my table (and the form field linked to it) I have a field for the IBAN
account number, which must be 2 Upper case characters A to Z, followed by 18
manadatory digits, and up to 28 total.

So in my input mask I have this:
LL00\-0000\-0000\-0000\-0000\-9999\-9999;;
Click to expand...

and it works fine.

But when the user enters less than 20 characters total (including the two
letters at the start and at least 18 digits) Access gives a very unfriendly

''The value you entered isn't appropriate for the input mask
'>LL00\-0000\-0000\-0000\-0000\-9999\-9999;;' specified for this field"

error message!

So I want to try and make this into a Validation Rule, then I can put a
Validation text message to help the user.

Has anyone managed to use optional numeric only wildcards in pattern strings
for Access form fields?

Can anyone help?

thanks

Philip
 

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

Create a Validation rule for IBAN Account nos in a form field 0
Validation Rule for number of characters (Loe Asked) 1
Date-time field in data entry form 3
Differents totals for each year of birth within a Field. 3
Phone Number Formatting 8
input mask for phone number 2
validation rule for unique number 5
Preserving input mask when using field in lookup for a second tabl 1

Top