How do I use a zip code starting with zero?

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!
 
B

Brian Bastl

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
 
J

Joseph Meehan

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
My cell is formatted to General and I keep losing the number zero 3
I NEED A '0' (ZERO) IN FRONT OF THE ZIP CODE 7
Holding Zero Value 7
Novice trying to create zip code look-up 4
Can't mail merge a zip code starting with a zero (02657) 1
How to create a default field for zipcode with a zero beginning 3
Function to Count Zip Code Digits With Leading Zero 2

Top