How to create a Canadian Input Mask for the Post Code? in Access Database New users  
 |  Edit my Profile  |  Help
 
     
   
 
 
 
Grd 1/25/2006 8:17 AM PST
  Question
  Hi,

I have a table of Customer information and I have a PostCode field. I'm
getting some badly typed postcodes so someone suggested i put in an Input
Mask to prevent that from happening.

An example of a canadian postcode is M6J 2J9

Is this possible to do?

Any help would be wonderful

thanks
Janet
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Rick B 1/25/2006 8:31 AM PST
  Answer
  I believe this was just addressed yesterday. Please do a search and read
the previous posts. This exact same message was asked yesterday.

Please search for answers to common questions before posting a new thread.
That is why the old posts are retained.

Good luck,

--
Rick B



"Grd" <Grd@discussions.microsoft.com> wrote in message
news:3646FD1B-988C-42DB-8A60-0F1495D9DF0C@microsoft.com...
> Hi,
>
> I have a table of Customer information and I have a PostCode field. I'm
> getting some badly typed postcodes so someone suggested i put in an Input
> Mask to prevent that from happening.
>
> An example of a canadian postcode is M6J 2J9
>
> Is this possible to do?
>
> Any help would be wonderful
>
> thanks
> Janet


 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Grd 1/25/2006 9:57 AM PST
   
  Hi Rick,

I can't seem to find the post you're refering to. I've searched for Canada,
PostCode, Input Mask etc but can't seem to find it. Was the answer in this
newsgroup

Thanks
Janet

"Rick B" wrote:

> I believe this was just addressed yesterday. Please do a search and read
> the previous posts. This exact same message was asked yesterday.
>
> Please search for answers to common questions before posting a new thread.
> That is why the old posts are retained.
>
> Good luck,
>
> --
> Rick B
>
>
>
> "Grd" <Grd@discussions.microsoft.com> wrote in message
> news:3646FD1B-988C-42DB-8A60-0F1495D9DF0C@microsoft.com...
> > Hi,
> >
> > I have a table of Customer information and I have a PostCode field. I'm
> > getting some badly typed postcodes so someone suggested i put in an Input
> > Mask to prevent that from happening.
> >
> > An example of a canadian postcode is M6J 2J9
> >
> > Is this possible to do?
> >
> > Any help would be wonderful
> >
> > thanks
> > Janet
>
>
>
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Jerry Whittle 1/25/2006 8:31 AM PST
  Answer
  As a rule, I do not recommend input masks for either postal codes or
telephone numbers. The first time that you have to enter a zip code for one
of your neighbors way down south or try to add the Queen of England's phone
number, you'll see what I mean.
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Grd" wrote:

> Hi,
>
> I have a table of Customer information and I have a PostCode field. I'm
> getting some badly typed postcodes so someone suggested i put in an Input
> Mask to prevent that from happening.
>
> An example of a canadian postcode is M6J 2J9
>
> Is this possible to do?
>
> Any help would be wonderful
>
> thanks
> Janet
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Joan Wild 1/25/2006 10:19 AM PST
  Answer
  While I agree with the general sentiment that input masks are more of a
hindrance than a help, this would be one exception.

If you are absolutely sure that you'll only deal with Canadian addresses,
then an input mask really helps. Nothing slows down a touch typist faster
than a Canadian postal code.
>L0L\ 0L0;0;


--
Joan Wild
Microsoft Access MVP

Jerry Whittle wrote:
> As a rule, I do not recommend input masks for either postal codes or
> telephone numbers. The first time that you have to enter a zip code
> for one of your neighbors way down south or try to add the Queen of
> England's phone number, you'll see what I mean.
> --
> Jerry Whittle
> Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
>
>
> "Grd" wrote:
>
>> Hi,
>>
>> I have a table of Customer information and I have a PostCode field.
>> I'm getting some badly typed postcodes so someone suggested i put in
>> an Input Mask to prevent that from happening.
>>
>> An example of a canadian postcode is M6J 2J9
>>
>> Is this possible to do?
>>
>> Any help would be wonderful
>>
>> thanks
>> Janet


 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Grd 1/25/2006 2:11 PM PST
   
  Hi Joan,

Thanks thats what I was looking for.

Janet

"Joan Wild" wrote:

> While I agree with the general sentiment that input masks are more of a
> hindrance than a help, this would be one exception.
>
> If you are absolutely sure that you'll only deal with Canadian addresses,
> then an input mask really helps. Nothing slows down a touch typist faster
> than a Canadian postal code.
> >L0L\ 0L0;0;
>
>
> --
> Joan Wild
> Microsoft Access MVP
>
> Jerry Whittle wrote:
> > As a rule, I do not recommend input masks for either postal codes or
> > telephone numbers. The first time that you have to enter a zip code
> > for one of your neighbors way down south or try to add the Queen of
> > England's phone number, you'll see what I mean.
> > --
> > Jerry Whittle
> > Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
> >
> >
> > "Grd" wrote:
> >
> >> Hi,
> >>
> >> I have a table of Customer information and I have a PostCode field.
> >> I'm getting some badly typed postcodes so someone suggested i put in
> >> an Input Mask to prevent that from happening.
> >>
> >> An example of a canadian postcode is M6J 2J9
> >>
> >> Is this possible to do?
> >>
> >> Any help would be wonderful
> >>
> >> thanks
> >> Janet
>
>
>
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
  Return to Microsoft Communities  Notify me of replies