Community
Showing results for 
Search instead for 
Do you mean 
Reply

Foce the phone number mask formatting

Copper Contributor
Posts: 66
Country: USA

Foce the phone number mask formatting

I know that if you copy out the phone number into another field, and then set the mask on the phone field, then copy the number back into that field, the formatting gets applied (%%%) %%%-%%%.

 

I have two questions about this:

 

1) can I just force the formatting on all the numbers in the database without copy and paste?

 

2) Is a way to force the formatting when you enter a phone number manually? So when someone types in a 10 digit number it just automatically sets the formatting and does not allow them to enter free-form numbers. 

 

ACT! by Sage Premium 2010 Version 12.1.181.0, Hot Fix 1

 

Thanks in advance.