Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 01-30-2003, 02:34 AM   #1
angelrichardson
Guest
 
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
Rich
Guest
 
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
christheancient
Member
 
Join Date: Dec 2002
Location: Portsmouth - UK
Posts: 41
Thanks: 0
Thanked 0 Times in 0 Posts
christheancient
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

Chris

__________________
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
angelrichardson
Guest
 
Posts: n/a
thankyou

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

  Reply With Quote
Reply

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
General
Tables
Queries
Forms
Reports
Macros
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