Input masks

[Bill]

I set up a control on a form wherein users
enter telephone numbers. In the properties
table for that control, I specified that the input
mask be configured such that the numbers
would enter into a field like: (___) ___-____.
Thus the user would only have to enter the
10 digits that comprise the telephone number.
As I looked at the corresponding HELP text,
I thought I understood that the entered number
would appear formatted within the table field
defined by the datasource for the control. Such
does not seem to be the case, as what gets
stored in the table is the un-formatted 10 digits.
How do I get the telephone number stored as
formatted, i.e., including the formatting literals.
Thanks,
Bill

 

[AlCamp]

Bill,
Check out the Format Property in Help. Particularly the "Second" part of
an Input Mask.
There are three parts to the InputMask property

(999) 999-9999;0
would store the "literal" characters along with the digits, and
(999) 999-9999;1
would not.
hth
Al Camp

 

[Dirk Goldgar]

I set up a control on a form wherein users
enter telephone numbers. In the properties
table for that control, I specified that the input
mask be configured such that the numbers
would enter into a field like: (___) ___-____.
Thus the user would only have to enter the
10 digits that comprise the telephone number.
As I looked at the corresponding HELP text,
I thought I understood that the entered number
would appear formatted within the table field
defined by the datasource for the control. Such
does not seem to be the case, as what gets
stored in the table is the un-formatted 10 digits.
How do I get the telephone number stored as
formatted, i.e., including the formatting literals.
Thanks,
Bill

You need to specify 0 for the second semicolon-delimited section of the
input mask. Did you? Your control's Input Mask property should
probably look like this:

!(999) 000-0000;0;_

 

[Bill]

Thanks Dirk, the second argument was in fact null/empty,
as inserted from a selection list of masks.
Bill

 

[Bill]

Thanks Al, as I reported to Dirk, the second argument
was in fact null/empty, as inserted from a selection list
of masks.
Bill