displaying zips in access 2003

[Guest]

How do you force a leading zero to be displayed for zip codes in both the
table and form for ACCESS 2003?

 

[Dirk Goldgar]

How do you force a leading zero to be displayed for zip codes in both
the table and form for ACCESS 2003?

Make the field a text field. If you already have numbers in that field
from which the leading zeros have been dropped, run an update query to
put them back; e.g.,

UPDATE YourTable
SET YourTextField = Format(YourTextField, "00000");

**NOTE: That assumes that you only have five-digit zip codes. If you
have a mix of 5-digit and 9-digit codes, it's more complicated.

 

[Guest]

Thanks

Make the field a text field. If you already have numbers in that field
from which the leading zeros have been dropped, run an update query to
put them back; e.g.,

UPDATE YourTable
SET YourTextField = Format(YourTextField, "00000");

**NOTE: That assumes that you only have five-digit zip codes. If you
have a mix of 5-digit and 9-digit codes, it's more complicated.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)