On 9/23/2010 3:15 PM, Ron Rosenfeld wrote:
On Thu, 23 Sep 2010 17:23:00 +0200, "Charlotte wrote:

Is is possible to create an UDF, which validates an IBAN number accoring to
this:

http://en.wikipedia.org/wiki/Interna...ing_the_I BAN

TIA,


Actually, the valid two letter country codes can be deduced from the IBAN
fields listed in the article you cite, so it should be relatively simple for
you to set up a lookup table.
--ron

If you create what looks like a free acc't there's a file here you may
be able to use:

http://www.utteraccess.com/forum/IBA...ode=linearplus

I needed a function to validate IBAN numbers but couldn't find one.
Came across some difficulties but found help on UtterAccess (Brent
Spaulding (UtterAccess: datAdrenaline) )
So here it is for anyone that may need an IBAN validator.
I also created a couple of icons to show near the IBAN textbox.
A check for a Valid IBAN and a Cross for an Invalid IBAN.
Enclosed in attachment:
* 2007 format
* 2000 format (only tested on Access 2007)
* Valid and Invalid Icons in png format.
Attached File Valid IBAN.zip ( 58.56K ) Number of downloads: 174