how do I force leading zeros (as in ZIPs) to be displayed in Acce.

R

Ralph

How do I force a leading zero in a ZIP code to be displayed in both the table
and form in ACCESS 2003? The table was imported from EXCEL where it was
defined as a ZIP under Special cell formatting...
 
D

Dennis

During the import, you can define the field to be text when it is imported
instead of numeric and this would therefore keep the leading zero.
 
Top