formatting phone numbers

[synergy]

Phone numbers. need to be properly spaced.

i.e (000)-000-0000)

I would like to know how to get FM5 to place the "-" appropriately?

Any advice will be greatly appreciated.

[DykstrL]

You can use three fields, the data entry field=Phone[text], and 2 calculation fields.

PhoneToNum[calc]=NumToText(Abs(TextToNum(Phone)*10000000))

[This converts the phone number to just a number, ignoring any other format or text the user may enter - then back to text with just the numerics]

PhoneCalc[calc]="("& Middle(PhoneToNum,1,3) &")"& Middle(PhoneToNum,4,3) &"-"& Middle(PhoneToNum,7,4)

Place the Phone field on the layout and make it non-printing, then place the PhoneCalc field over it and make the color white so the Phone field does not show through it. Make sure the Field format for PhoneCalc does not allow entry or is not in the tab order. If browse mode, when you tab or click into the overlayed fields, it will enter the Phone field, enter the number in any format, and when you tab or click out of the field, the reformatted phone number will appear and will print.