Go Back   Access World Forums > Microsoft Access Discussion > General

Thread Tools Rate Thread Display Modes
Old 01-30-2003, 02:34 AM   #1
Posts: n/a
Unhappy Post codes/ Zip codes input masks

Hi there, im a student currently doing my a level ICT coursework using microsoft access and i have become frustrated with my tables because i cannot find an input mask suitable for a UK postcode AND a USA zip code, i have, for the moment, taken the input mask off altogether and i have to trust that my typing will be correct, but can anyone help me come up with a sitable input mask, i would be very grateful for the help!

  Reply With Quote
Old 01-30-2003, 02:41 AM   #2
Posts: n/a
They should be two separate fields, therefore the input masks would be different anyway
  Reply With Quote
Old 01-30-2003, 12:30 PM   #3
Join Date: Dec 2002
Location: Portsmouth - UK
Posts: 41
Thanks: 0
Thanked 0 Times in 0 Posts
Can't help on Zip Codes.

However, the very best mask I have found (and use consistently) for UK Post Codes can be a tricky one to make work properly. It can be tamed as follows.

LAaa 0LL. In other words, the first character is always a letter and is required, the second character can be a letter or a digit but is required (as in M6 or SW10), the next two characters may be letters or digits and may be there or not. The last three characters are always a digit folloed by two letters.

The final mask comes out as...

>LAaa\ 0LL;0;*

Note that there must be a space just after the back slash.

As a US Zip Code bears no resemblance to a UK Post Code, you will have to choose a method of entering these codes that is country dependent.

Hope all this helps


OK! So I'm stoopid. But at least I'm good at it!
christheancient is offline   Reply With Quote
Old 02-11-2003, 07:46 AM   #4
Posts: n/a

thankyou very much for that code, i have found it helpful, i hope i can use it in my database! thanks again

  Reply With Quote

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

All times are GMT -8. The time now is 08:21 PM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World