How do I use a zip code starting with zero?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I used ACCESS for a database of people's names and mailing addresses. One
zip code starts with zero, but it is dropped when I move to another field.
Can't figure out how to get it to stay in and print!
 
Hi,

Change the Zipcode field in the table from numerice data type to text. You'd
only want it as a number if you were to perform calculations with it.

Brian
 
Brian said:
Hi,

Change the Zipcode field in the table from numerice data type to
text. You'd only want it as a number if you were to perform
calculations with it.

Brian
Click to expand...

You will also need text if you have any non-US postal codes.
 

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 to enter zip starting with 0 (zero) 10
Editing a cell in Excel spreadsheet 2
How to create a default field for zipcode with a zero beginning 3
I NEED A '0' (ZERO) IN FRONT OF THE ZIP CODE 7
Novice trying to create zip code look-up 4
Zip Codes Dropping Leading Zero 3
My cell is formatted to General and I keep losing the number zero 3
Holding Zero Value 7

Back
Top