Phone Number mask problems

[preston2]

I have a character field for the customers phone number. It uses the Phone(US/Canada) mask.

The problem is users are entering () - and spaces which screws up the phone number displaying right on invoices and such.

Once they do that it seems impossible to clear the trash out even when re-entering the phone number.

Is there anyway to stop them from being able to do anything but enter the number 0-9 ?

Also I have the "Do not store mask literals in filed" checked

Or do I just have to turn off the mask.

[G Gabriel]

Re: Phone Number mask problems

Many ways, an easy one:
In the OnDepart event of the field object/control, use this script:

tel_fld=remspecial(tel_fld)

[GGandhi]

Re: Phone Number mask problems

Is there anyway to stop them from being able to do anything but enter the number 0-9 ?

I just tested in a dummy table, when you have a mask -Phone(US/Canada), it seems to be the default behavior. tested in default browse and default form only.
I was not able to enter anything but 0-9 and when actually enter "(", ")", "-" I takes them if they are supposed to be there if not it is not taken.
may be that there is something more to it than the posted material.

[preston2]

Re: Phone Number mask problems

Many ways, an easy one:
In the OnDepart event of the field object/control, use this script:

tel_fld=remspecial(tel_fld)

Would not work using the field (object) name from the form. It required a variable. Had to modify it.

dim phone2 as c
phone2 = parentform.phone
parentform:phone.value=remspecial(phone2)

[preston2]

Re: Phone Number mask problems

I just tested in a dummy table, when you have a mask -Phone(US/Canada), it seems to be the default behavior. tested in default browse and default form only.
I was not able to enter anything but 0-9 and when actually enter "(", ")", "-" I takes them if they are supposed to be there if not it is not taken.
may be that there is something more to it than the posted material.

Same with me but some how some of them can figure out how to screw it up.

It shows fine on the forms even if they use those symbols where allowed. It is when it is displayed on a report using,

MASK(PHONE,"( )| ...

in the rich text that it sometime rears its head.

[G Gabriel]

Re: Phone Number mask problems

Would not work using the field (object) name from the form. It required a variable. Had to modify it.

dim phone2 as c
phone2 = parentform.phone
parentform:phone.value=remspecial(phone2)

That is the field object's name!
No need for variable.
You could also reference the field's name but you have to preface it with the table name.

[preston2]

Re: Phone Number mask problems

That is the field object's name!
No need for variable.
You could also reference the field's name but you have to preface it with the table name.

I did not try it prefacing the field with the table name but the other ways I tried kept getting "variable not found" error messages so I created a variable.

[G Gabriel]

Re: Phone Number mask problems

I didn't know if you were doing this from a form, an xdlg or something else. When I put tel_fld, I thought you will understand to use the proper field name in whichever context you are doing that.

[preston2]

Re: Phone Number mask problems

When I put tel_fld, I thought you will understand to use the proper field name in whichever context you are doing that.

I guess not. I put fields on a form, they also have object names so to me just saying tel_fld means the field anyway you need to access it.
Stating "In the OnDepart event of the field object/control" also lead me to believe you where talking about the field on the form and not directly referring the field in the table. Besides a user would never edit a table field directly so to me that meant the field/object on the form.

table->tel_fld would have left no doubt that you a referring to the field in a table and not the field on a form.

Just a slight misunderstanding but that is ok because it works either way.