VIN Input Mask

[JohnSteven]

Hi All,

I'm attempting to put together an input mask that will validate a Vehicle Identification Number on automobiles and need some help. If you click on the site listed and read the requirements of a VIN you'll see what I'm getting at.

http://frwebgate.access.gpo.gov/cgi-bin/get-cfr.cgi?TITLE=49&PART=565&SECTION=6&TYPE=TEXT

It is pretty complex, but if someone can steer me in the right direction I'll give it my best shot and post back with my results.

Thanks in advance
JohnSteven

 

[WildHare]

Well, I took a brief glance through that document, and like most government edicts, it started to give me a headache..

It looks like you will NOT be able to do a straight-forward INPUT MASK in the table - there are too many variables on the VIN characters that depend on vehicle characteristics. You'll probably need to build a small table or two with the matching pairs if characters needed, plus that check digit thing, and write a function to either "create" the VIN, or check its entry for validity.

It does look do-able though, just not in a simple table field input mask.

Jim Me? Ambivalent? Well, yes and no....
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm