 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / November 2005zipcode
I have a access data I'm doing a mailing went into (report) and (labels) put the zipcode comes out as "123456789" instead of "12345-6789 any idea the (input mask) shows the zip as 12345-6789 sincerely Alex > I have a access data I'm doing a mailing > went into (report) and (labels) put the zipcode > comes out as "123456789" instead of "12345-6789 > any idea the (input mask) shows the zip as 12345-6789 > sincerely Alex You are using a mask (00000-9999;;_) to enter the zip code, but you have not set up the mask to be saved with the data (00000-9999;0;_). Using an Unbound text control: =[City] & ", " & [State] & " " & IIf (Len([ZIP])>=9,Left([ZIP],5) & "-" & Right([ZIP],4),Left([ZIP],5)) 12345 or 12345- will print 12345 123456789 or 12345-6789 will print 12345-6789  SignatureFred Please respond only to this newsgroup. I do not reply to personal e-mail |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.