A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

zipcode



 
 
Thread Tools Display Modes
  #1  
Old November 30th, 2005, 05:32 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default zipcode

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


  #2  
Old November 30th, 2005, 05:46 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default zipcode

The Input Mask property controls how input looks but the masks are not
generally stored with the data. If you want to control how output looks on
a report/labels, use the Format property.

"alex" wrote in message
news:lmljf.6534$AB2.2696@trnddc08...
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



  #3  
Old November 30th, 2005, 06:27 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default zipcode

On Wed, 30 Nov 2005 17:32:01 GMT, alex wrote:

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


Answered elsewhere.
Please do not multi-post. If you feel you must post the same question
to more than one newsgroup (and it's seldom necessary), cross-post by
adding each additional newsgroup in the To Newsgroups: box, separated
by a comma.
This way an answer in one newsgroup will be seen in each of the
others. More readers will see the response and learn, and less time
will be spent on duplicate answers.

See Netiquette at http://www.mvps.org/access

It's a great site to visit anyway.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
import zipcode from excel to access with leading 0 Dawn General Discussion 2 September 13th, 2005 10:39 PM
zipcode problem with mailmerge using excel. pamsf Mailmerge 1 May 10th, 2005 04:46 PM
Zipcode table Tony Running & Setting Up Queries 1 January 11th, 2005 02:41 PM
Query for zipcode table Tony Running & Setting Up Queries 2 January 6th, 2005 01:47 PM
zipcode fills in city MusicMoreThanTech General Discussion 1 October 17th, 2004 09:17 PM


All times are GMT +1. The time now is 12:18 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.