Results 1 to 7 of 7
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Brookline, Massachusetts, USA
    Posts
    606
    Thanks
    17
    Thanked 0 Times in 0 Posts

    Access 97 Zip code mask

    I have an address list table. I used the 9-digit Zip code mask and the results are correct. 02170-, or 02170-1234 when all 9 digits are input. I also told the mask Wizard to store the literal dash in the database. However, when I created a concatenated field CityStZip, everything appears except the dash in the 9-digit zip. I get "Boston, MA 021701234". What am I doing wrong?
    Thanks, Howard

  2. #2
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Tennessee
    Posts
    194
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access 97 Zip code mask

    did you look in the table to see if the dash had been saved or not

  3. #3
    3 Star Lounger
    Join Date
    Feb 2001
    Location
    NYC,USA,Earth
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access 97 Zip code mask

    I tested this and it worked for me. Here's what my input mask looks like from the table design property sheet:

    00000-9999;0;_

    If all else fails you can use the Left and Right functions and "-" to concatenate the result you want.

  4. #4
    Star Lounger
    Join Date
    Dec 2000
    Location
    Hellertown, Pennsylvania, USA
    Posts
    53
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access 97 Zip code mask

    Howard,

    Where are you creating the concatenated field? Is it in a report? I used the concatenation in a query and it worked fine.

  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Brookline, Massachusetts, USA
    Posts
    606
    Thanks
    17
    Thanked 0 Times in 0 Posts

    Re: Zip code mask: Solved!

    Thanks for all the responses. Paul, your copy of the mask worked fine. I had a typo in mine, which I didn't notice, even after eyeballing it several times.
    Howard

  6. #6
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Brookline, Massachusetts, USA
    Posts
    606
    Thanks
    17
    Thanked 0 Times in 0 Posts

    Re: Access 97 Zip code mask

    Don't know if you saw the reply under my original post, so I'm copying you here.
    Thanks for all the responses. Paul, your copy of the mask worked fine. I had a typo in mine, which I didn't notice, even after eyeballing it several times.
    Howard

  7. #7
    3 Star Lounger
    Join Date
    Feb 2001
    Location
    NYC,USA,Earth
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access 97 Zip code mask

    Glad to hear you got it working and my effort in posting the mask helped. I look forward to the day when I don't have to rely on my stupid fingers for input devices <img src=/S/wink.gif border=0 alt=wink width=15 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •