title: Validate Postcode in Access?
body: <p>I have been searching around for a way to do this but I am finding it hard :(</p>
  
  <p>I am very very very new to VBA (In fact, I have not used it) but I am determined !</p>
  
  <p>What I want to do is validate a postcode so that it formats it and checks it. I have tried Input mask and validation, but this are not perfect. So I have turned to VBA.</p>
  
  <p>I have found examples of code, and put them into VBA, but I can't get it to do anything :(</p>
  
  <p>It needs to work with these postcodes ...</p>
  
  <p>A9 9AA</p>
  
  <p>A9A 9AA</p>
  
  <p>A99 9AA</p>
  
  <p>AA9 9AA</p>
  
  <p>AA9A 9AA</p>
  
  <p>AA99 9AA</p>
  
  <p>If anyone could help it would be great. But what would be best if someone could give me a database with the validator in, so I could see it in action and learn. But anything would be good. Just how to make it work would be good :) . What I have done is copy and pasted the code <a href="http://www.tek-tips.com/faqs.cfm?fid=6344" rel="nofollow">Here</a> into a module and hoped for the best, but nothing happened ? </p>
  
  <p>So any help would be good.</p>
  
  <p>Thank you</p>