By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,528 Members | 1,375 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,528 IT Pros & Developers. It's quick & easy.

zipcode

P: n/a
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
Nov 30 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
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.

Nov 30 '05 #2

P: n/a
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

Nov 30 '05 #3

P: n/a
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.

Nov 30 '05 #4

P: n/a
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.

Nov 30 '05 #5

P: n/a
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 (555) 555-1212 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.
Nov 30 '05 #6

P: n/a

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

Dec 1 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.