By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,193 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

Need help with zip code issue on lables

P: 1
I'm using MS Access; Is there an easy way to add a "0" in front of my zip codes? I am printing address lables and the "0" is not showing up? Help!
Oct 10 '07 #1
Share this Question
Share on Google+
4 Replies

Expert 100+
P: 1,351
make the datatype varchar instead of number
Oct 10 '07 #2

Expert 5K+
P: 8,127
or else simply concadinate a 0 in front of the zipcode.
Oct 11 '07 #3

Expert 5K+
P: 5,821
Moving to the Access forum....
Oct 11 '07 #4

Expert 2.5K+
P: 3,532
Or, keeping the ZipCode as a numeric datatype, use formatting, i.e Format(MyZipCode, "00000")

When defining the datatype for a field that contains digits only, this test should be applied:

Will the field ever be used for mathematical calculations or for comparative purposes ?

If the answer is YES, then use a numerical datatype.

Examples: quantities, ratings

If the answer is NO, then use a text datatype.

Examples: Zip Codes, ID Numbers, telephone numbers

Welcome to TheScripts!

Linq ;0)>
Oct 11 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.