Input masks

  • Thread starter Thread starter Bill
  • Start date Start date
B

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
 
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
 
Bill said:
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;_
 
Thanks Dirk, the second argument was in fact null/empty,
as inserted from a selection list of masks.
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
 
Back
Top