why does zipcode in mailing labels print without seperator

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a mailing label report and the zipcode + four run together (don't
have the "-" seperator between basic zip and +4. The table has input mask of
00000\-9999;0;_ (I used the input mask wizard which asked if I wanted to
have data stored in the same format and I said Yes.
The odd thing is that other queries and reports seem to be OK and print out
correctly - Example 12345-6789 but on labels it comes out 123456789
HELP
 
Seawulf:

Add the same input mask to the control that displays the zip information on
the report. That will assure formatting. The input mask you used, allows
Access to store the data without the hyphen. Queries pick up input masks
from table definitions so that's why they display there correctly. Unless
you dragged the zip control on the report from the table field list of your
query, the input mask may not have been carried over, so just add it.
 
Back
Top