Best Post Code Validation?

[dynamix]

Well the input mask in Access really sucks.. Though Post code is a tricky one. Just wondering if any of you guys have any solutions?

Not urgent, just interested . Would love to use something..

 

[modest]

This post kind of really sucks. There's no question.. how would we have a solution?

 

[Mile-O]

Have you even bothered to search? Post codes are asked quite a lot.

 

[jgc31]

On a more helpful note and assuming that you are using UK postcodes the following will work when set as the input mask of the relavent field

L?09? 0>LL

this will cover the following

W1 2AB

LA22 6TZ

WC1X 4FG


If you are looking at Germany much more straightforward

00000

eg 85551

The help file is fairly self explanatory

 

[Mile-O]

Personally, I'd split the UK post code into two separate parts.

 

[dynamix]

Thanks for that jgc. I'll give it a shot .

(Sorry mods, if this topic was not relevant)

 

[modest]

No, I guess it is just me. Everyone else seemed to know what you were asking, I thought maybe this was a continuation from a different post and I had no clue what was going on. So I'll just stumble over this brief state of confusion and try to pick up the pieces g'luck

 

[Mile-O]

No, I guess it is just me. Everyone else seemed to know what you were asking, I thought maybe this was a continuation from a different post and I had no clue what was going on. So I'll just stumble over this brief state of confusion and try to pick up the pieces g'luck

lol, post code = zip code

 

[jempie]

jgc31/ all,

I am trying to use this input mask as a validation rule against some data in another table.

I want to create an append query that will append the records that meet the input mask.

Can anyone help?

Jempie

On a more helpful note and assuming that you are using UK postcodes the following will work when set as the input mask of the relavent field

L?09? 0>LL

this will cover the following

W1 2AB

LA22 6TZ

WC1X 4FG


If you are looking at Germany much more straightforward

00000

eg 85551

The help file is fairly self explanatory