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

  • Thread starter Thread starter Guest
  • Start date Start date
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...
 
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
Zip Codes Dropping Leading Zero 3
avoiding truncating leading zero 4
Droping Leading Zeros In Table 4
Keeping Leading Zeros; How Please ? 2
Help with leading-zero-data-matching Db1 vs Db2 both MF DLs. 8

Back
Top