PC Review


Reply
Thread Tools Rate Thread

How do I make my 5 digit zip codes print correctly with 9 digit f.

 
 
=?Utf-8?B?QmpheQ==?=
Guest
Posts: n/a
 
      22nd May 2006
I am trying to start using zip+4 -- I changed the zip code field size in my
table from 5 to 9 and the input mask to 00000\-9999;; The table displays the
5 digit codes and the 9 digit codes correctly. (FYI it is a text field.)

I also changed the formatting on all my printing (reports). HOWEVER, this
is where the problem begins. All 9 digit codes print correctly, the 5 digits
codes DO NOT! The 5 digit codes print like this "3-0344" instead of the
correct "30344-". As if it were starting from the right instead of the left.

I'm sure this is a simple fix, I'm just not an Access expert and I'm
stumped. Thanks for any help.


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I make my 5 digit zip codes print correctly with 9 digit f. =?Utf-8?B?QmpheQ==?= Microsoft Access 8 31st May 2006 12:55 AM
Access 2000 not printing 9 digit zip codes correctly =?Utf-8?B?Y2F3ZXNx?= Microsoft Access Reports 3 12th Oct 2005 01:58 AM
Tell users how to sort 5 digit and 9 digit zipcodes correctly aft. =?Utf-8?B?amFtZXMubWNnb3VnaEBjb21jYXN0Lm5ldA==?= Microsoft Excel New Users 1 18th Feb 2005 12:59 AM
How do I correctly sort a list of zip codes that has both 5-digit. =?Utf-8?B?dmluY2U0OEB2ZXJpem9uLm5ldA==?= Microsoft Excel Misc 3 19th Nov 2004 04:52 AM
Sorting of mixed zip codes (5 digit and 9 digit) in ascending order =?Utf-8?B?Tk1fRnJlbmNobWFu?= Microsoft Excel Worksheet Functions 3 26th Jan 2004 09:08 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:29 PM.