zipcode

[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

[Steve]

The input mask is by default only for formatting data as it is typed
in. There is an input mask property you can set to store the data with
the mask in place, which will store your zip codes as 12345-6789
instead of 123456789.

[GH]

Alex,

An input mask is just that, an input mask. Unless you specified in the
table field definition to also store the data with a masked format, the
only time the mask is shown is when you are inputting data into a text
box with an associated mask. To get that masked data in a report, you
need to make sure the mask formatting is attached to the mask property
of the text field bound to the zip code on the report. If you have
already done this, my apologies, as this is the only fix that comes to
my mind.

- GH

[alex]

sorry. please explain were the input mask that youre
talking about. i'm new to "access"
alex
"Steve" <th*********@gmail.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

The input mask is by default only for formatting data as it is typed
in. There is an input mask property you can set to store the data with
the mask in place, which will store your zip codes as 12345-6789
instead of 123456789.

[Steve]

The input mask you referred to is either in your table or in your
textbox. It's the same one you mentioned in your original post.

[salad]

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

An input mask is useful for inputting data into a field. When you
define an input mask, you can either keep formatting characters or not.
For example, you might with [phone] stored in a table or
5555551212. You can check this out by going into a table (or form),
hitting the ... button on the right of the property sheet for that field.

Then you can format the information the way you want. You need to find
ways to create "custom" formats in help. Look for Format Function and
look at the "see also" links.

[Dean]

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

Instead of using a table, use a query to calculate your zip:

NewZip: Left$([YourZip],5) & "-" & Right$([YourZip],4)
If you get this worked out, you could use in an update query, then fix
your input mask to store the "-".