Input Mask in Access Table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

EKW - 24 Jul 2005 22:28 GMT

I recently converted an ACC97 database to ACC2003. During the process I seem
to have lost a custom input mask for phone #'s. It used to be H
281-555-6666--but it is missing from the table design. I can now use the
default telephone mask which would show as (281) 555-6666. QUESTION: If I
add the default telephone mask will I lose all my telephone #'s? When I do
add the new default mask will I have to retype all 500 telephone #'s to get
them in the right format? Or is there a way to convert the existing numbers
to the default format?
Thank you.

Signature

Kaye

Reply to this Message

John Vinson - 25 Jul 2005 07:32 GMT

>I recently converted an ACC97 database to ACC2003. During the process I seem
>to have lost a custom input mask for phone #'s. It used to be H
[quoted text clipped - 5 lines]
>to the default format?
>Thank you.

The input mask does two things:

- It constrains what the user can type on input
- It (optionally) adds formatting characters to the display

Changing an input mask will NOT delete or alter your stored data in
any way. It's not stored in the table as data; it's *just a formatting
tool*.

If you want an input mask - type it in! You're NOT restricted to the
masks provided by the wizard. If you were to type

\H\ 000-000-0000

into the Input Mask property of the field, just like that, as a text
string, you'll see that you should have your comfortable old mask
back.

John W. Vinson[MVP]

Reply to this Message

EKW - 26 Jul 2005 02:21 GMT

Thanks John. I really don't want the old one back as I'm changing the way
the info is to be displayed.
Questions: It seems that when I add the new default mask, the numbers
already in the table and forms don't change to the new mask. Which means
I'll have to retype or change them to display in the new format. Right? Is
there a trick to do this easily? I've got 5 or 6 hundred to do.

In order to get the new mask to show in the data entry forms and queries do
I have to delete the field with the old mask (in the query or form design)
and insert the field with the new mask?

When I analyze the query with Excel or publish with Word, will the mask
format be retained in Excel?
Thanks for your time,--
Kaye

> >I recently converted an ACC97 database to ACC2003. During the process I seem
> >to have lost a custom input mask for phone #'s. It used to be H
[quoted text clipped - 25 lines]
>
> John W. Vinson[MVP]

Reply to this Message

John Vinson - 26 Jul 2005 02:54 GMT

>Thanks John. I really don't want the old one back as I'm changing the way
>the info is to be displayed.
>Questions: It seems that when I add the new default mask, the numbers
>already in the table and forms don't change to the new mask. Which means
>I'll have to retype or change them to display in the new format. Right? Is
>there a trick to do this easily? I've got 5 or 6 hundred to do.

To change the way data is *DISPLAYED* (rather than controlling how
it's entered) use a Format property instead of a mask.

Exporting to Excel or to text will ignore both input masks and
formats. You'll need to use the Format() *function* to explicitly cast
the field into a new format.

John W. Vinson[MVP]

Reply to this Message