Phone number input mask

[AsMok]

hi all

I have this input masks for two phone numbers fields....

!"09"0\-000\-0000;;_
!"091-"000\-0000;;_

They work great on the form BUT it dose not store the first part of the area code 09 in the first field AND the whole area code 091 in the second one....
I want them to be stored with the 10 digits....

BTW;;
the table field type is text ...AND if I write the number on the form without the input mask it is stored with the ten digits in the table exactly as I want it....

THANKS IN ADVANCE ALL OF YOU

 

[theDBguy]

Hi. Try adding a zero in the second argument. For example:

!"091-"000\-0000;0;_

Hope that helps...

 

[AsMok]

ا

Hi. Try adding a zero in the second argument. For example:

!"091-"000\-0000;0;_

Hope that helps...

hi theDBguy.....

sadly nothing changed....
It still storing the same way.......

 

[theDBguy]

ا


hi theDBguy.....

sadly nothing changed....
It still storing the same way.......

Perhaps posting a sample db with test data will help clarify what's happening.

 

[AsMok]

Perhaps posting a sample db with test data will help clarify what's happening.

done​

 

[AsMok]

Perhaps posting a sample db with test data will help clarify what's happening.

HI....

The photo I attached to my last reply gave me an idea...
since the problem is in the table field... I should work on it...

I formatted the two table fields this way

"09"@@@@@@@@
"091"@@@@@@@

and then suddenly the problem solved ^_^

hope that is ok???

 

[theDBguy]

HI....

The photo I attached to my last reply gave me an idea...
since the problem is in the table field... I should work on it...

I formatted the two table fields this way

"09"@@@@@@@@
"091"@@@@@@@

and then suddenly the problem solved ^_^

hope that is ok???

Hi. Glad to hear you got it sorted out. Good luck with your project.