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

G

Guest

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...
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do I force leading zeros (as in ZIPs) to be displayed in Acce. 3
displaying zips in access 2003 2
LEADING ZEROS 7
Droping Leading Zeros In Table 4
Keeping Leading Zeros; How Please ? 2
Force leading zeros 2
Zip Codes Dropping Leading Zero 3
How to stop Excel from automatically truncating leading zeros 2

Top