InputMask

  • Thread starter Thread starter Pat
  • Start date Start date
P

Pat

I have an input mask in a database for zipcodes (i.e,
99999\-0000;;_) which should print the zipcode as
12345-6789; however, when I tried to print labels using
the label wizard, the hyphen doesn't print and it looks
like 123456789. This problem recently started. Prior to
two weeks ago, I could print labels with zip+4 w/o any
problems. Can anyone help me? Thanks
 
I have an input mask in a database for zipcodes (i.e,
99999\-0000;;_) which should print the zipcode as
12345-6789; however, when I tried to print labels using
the label wizard, the hyphen doesn't print and it looks
like 123456789. This problem recently started. Prior to
two weeks ago, I could print labels with zip+4 w/o any
problems. Can anyone help me? Thanks
Click to expand...

Your input mask 99999\-0000;;_ is not set up to be saved with the
data so it is only saving the data.

Change the mask to:
99999\-0000;0;_
and it will save the mask with the data. See Access Help.

Unfortunately it will not affect the already existing data.
To print the existing zip codes on your labels you can use:
= [City] & ", " & [State] & " " & IIf(Len([ZIP])>6,Left([ZIP],5) & "-"
& Right([ZIP],4),Left([ZIP],5))

The above should correctly print the zip whether or not it contains
the hyphen and whether or not is is a 5 or 9 digit code.

You can use an Update query using code similar to the above
(Left([ZIP],5) etc.) to update existing data to the new data including
the hyphen.
 
Back
Top