zipcode

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

alex - 30 Nov 2005 17:32 GMT

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

Reply to this Message

Pat Hartman(MVP) - 30 Nov 2005 17:46 GMT

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.

>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

Reply to this Message

fredg - 30 Nov 2005 18:27 GMT

> 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.

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message