PostCode Format 2

[Ajwebb]

Hi all,

I have a Macro that displays a message box saying "PostCode in Incorrect Format" and i would like this to be displayed if someone puts in a Postcode that is not in the format:

LLN NLL or LLNN NLL or 99999999 or 00000000

L = Letter
N = Numeric

Thanks for Any help

Ant

 

[jdegeorge]

Seems that you're trying to use the same post code field for US and other countries' post codes. You can't set multiple masks, so you'll have to do this with code behind the post code field's AfterUpdate property.

However, this won't be easy. First, you have to allow for 8 characters that can be formatted in many different ways. You'll need code to trap not only all the possible CORRECT formats, but you'll also have to develop code to trap all the INCORRECT possible formats.

Have you checked this field in the Customer table in Northwind? I haven't checked it myself, but do recall that there were international customers in the database so it's possible there could be logic on the related forms.

Jim DeGeorge

 

[Ajwebb]

Thanks Jim,

I'll have a look at the Northwinds database now and see what they have done.

Ant

 

[THWatson]

Ant
The code for postal codes for different countries is in the BeforeUpdate event in the Suppliers form.

Tom

 

[Ajwebb]

Thanks Jim and Tom,

Found it and have got it work on my database fine.

Would have been trying for ages otherwise.

Thanks Again

Ant

 

[jdegeorge]

Glad to help. Thanks for the star!

Jim DeGeorge