Formatting phone numbers

[Mark]

Hi -

I am trying to write a report that shows numbers in the (###) ###-####
format. In the table I have the field set for an input mask of !\(999")
"000\-0000;;_ and in the form I have input mask set to !\(000")
"000\-0000;;#. The trouble is when the report prints to screen or paper, I
get a ########## format. I tried to set the field in the report to the same
format but to no avail. What am I doing wrong. Any help is
appreciated...TIA

Mark

 

[Marshall Barton]

I am trying to write a report that shows numbers in the (###) ###-####
format. In the table I have the field set for an input mask of !\(999")
"000\-0000;;_ and in the form I have input mask set to !\(000")
"000\-0000;;#. The trouble is when the report prints to screen or paper, I
get a ########## format. I tried to set the field in the report to the same
format but to no avail. What am I doing wrong.

You're confusing input masks with display formats, they have
nothing to do with each other.

The input mask has an option to store the fixed characters
in the table field, so you could make the output look ok
using that feature. The default format of displaying the
entire text field will take care of it. Personally, I hate
input masks, so I would never do this.

In your case, the field in your table only contains the
string of digits, so you should use a custom format on the
text box displaying the field:
(@@@) @@@-@@@

Check Format Property in Help for all the options you can
use in custom formats.

 

[Mark]

Thanks for the help it worked great!

Mark

You're confusing input masks with display formats, they have
nothing to do with each other.

The input mask has an option to store the fixed characters
in the table field, so you could make the output look ok
using that feature. The default format of displaying the
entire text field will take care of it. Personally, I hate
input masks, so I would never do this.

In your case, the field in your table only contains the
string of digits, so you should use a custom format on the
text box displaying the field:
(@@@) @@@-@@@

Check Format Property in Help for all the options you can
use in custom formats.