[AccessD] Zip code format

Kathryn Bassett kathryn at bassett.net
Mon Jul 11 22:39:34 CDT 2005


In my table (members), I have a text field called Zip. The input mask is 00000\-9999;;_

Some people I have the 5 digit code, and others the zip+4, so this works. When I look at a query, a person's zip will show up as 91502- or 91006-2046 as I expect. However, when I make the mailing labels, I get 910062046 instead of 91006-2046. The 91502- does correctly show as 91502 without the dash.

In the table field definition, there is a space for "format" but if I put the same 00000\-9999;;_ I still get same result. There is no "predefined format" in the drop down box.

What do I do? This is a flat database with only 28 records, so I've got some play leeway.

--
Kathryn Rhinehart Bassett (Pasadena CA)
"Genealogy is my bag" "GH is my soap"
kathryn at bassett.net
http://bassett.net   




More information about the AccessD mailing list