Best Post Code Validation?

dynamix

Registered User.
Local time
Today, 05:58
Joined
Feb 9, 2005
Messages
38
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..
 
This post kind of really sucks. There's no question.. how would we have a solution?
 
Have you even bothered to search? Post codes are asked quite a lot.
 
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
 
Personally, I'd split the UK post code into two separate parts.
 
Thanks for that jgc. I'll give it a shot :).

(Sorry mods, if this topic was not relevant)
 
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
 
modest said:
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
 
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

jgc31 said:
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
 

Users who are viewing this thread

Back
Top Bottom