Phone number input mask (1 Viewer)

AsMok

IT IS ME ^_^
Local time
Today, 05:44
Joined
Sep 4, 2019
Messages
64
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 (y)
 

theDBguy

I’m here to help
Staff member
Local time
Today, 05:44
Joined
Oct 29, 2018
Messages
16,600
Hi. Try adding a zero in the second argument. For example:

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

Hope that helps...
 

AsMok

IT IS ME ^_^
Local time
Today, 05:44
Joined
Sep 4, 2019
Messages
64
ا
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

I’m here to help
Staff member
Local time
Today, 05:44
Joined
Oct 29, 2018
Messages
16,600
ا


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

IT IS ME ^_^
Local time
Today, 05:44
Joined
Sep 4, 2019
Messages
64
Perhaps posting a sample db with test data will help clarify what's happening.
done​

صورة1.png
 

Attachments

  • inputMask.accdb
    768 KB · Views: 28

AsMok

IT IS ME ^_^
Local time
Today, 05:44
Joined
Sep 4, 2019
Messages
64
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

I’m here to help
Staff member
Local time
Today, 05:44
Joined
Oct 29, 2018
Messages
16,600
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.
 

Users who are viewing this thread

Top Bottom