Consult a mobile phone number with "# # # # # # # - # # # #" format input and display prob-CodePudding

Access VBA programming, when enter the phone number with "# # # # # # # - # # # #" number display; In view the data (the binding table), have also been "# # # # # # # - # # # #" display, can you tell me how to implement??

Msgbox format (12345678901 #, "# # # # # # # - # # # #") can achieve similar functionality,

CodePudding user response:

The Mask attribute set MaskEdBox controls if you can. :)

CodePudding user response:

reference 1st floor bcrun response:

the Mask attribute set MaskEdBox controls if you can.

thank you very much for your reply!
MaskEdBox where can control, please call out (remember to play Access2002, 2003 controls many, now Acess2007, 2010 is only a few controls)?

CodePudding user response:

Character type words can do

 
The Format (" 15900000111 ", "@ @ @ @ @ @ @ - @ @ @ @")