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.
 
Back
Top