I search a plug-in (if possible free) or a way to format automatiquely phone numbers. I mean user enter 0102345678 in the field, after he leave the field the value is displayed ass 01 02 34 56 78 (but if possible without change of the value put in the field 0102345678, then when user need to edit this field, he will get 0102345678 to modify).

Thanks every one

Duplicate post: reply under Define Fields forum.

no plug in

calculation

Case(IsEmpty(Physician's Phone);"";Phone_Format_Options = "(###) ###-####" and Length(Physician's Phone) =10;"(" & Left(Physician's Phone; 3) & ") " & Middle(Physician's Phone; 4; 3) & "-" & Right(Physician's Phone;4);