simple text formatting

[George Swisher]

I have moved from ACCESS to FM and learning more about formatting field. I have a text field where users can enter a phone number only with no dashes or "( )". I want to validate the field where they must enter all ten number (areaCode phoneNumber) with no other characters. Then I want the field to display, but not store, the data as (xxx) xxx-xxxx. How can I do this?

[Lee Smith]

Hi George,

I see you are using v5, this has become a lot easier in v7

This topic comes up from time to time, I just did a search for Phone and Format and got the Maximum Hits of 200. However, you would really have to go back to find much about how to do this in v5.

I attached this file click here

To this thread Click Here

HTH

Lee

[George Swisher]

thanks!

I will take a look at it.