Lee Smith Posted February 11, 2010 Share Posted February 11, 2010 (edited) We get questions about how to format a text field so that the user doesn't override fomatting set place by the developer. In orther words, the users will paste in data from the clipboard, that uses a different fonts, or they type in a phone number XXX-XXX-XXXX or XXXXXXXXXX, etc and you want it to display (XXX) XXX-XXXX etc. You can control this somewhat by using the Auto Enter >> Calculated Value. There are several example files showing the use of the Auto Enter Function, but sometimes we spend a lot of effort spelling out the steps involve. The purpose of this tip, is to show visually the steps. [color:blue]To start, you need to go into the Manage Database (a.k.a. Define Fields). [color:blue]Next select the checkbox "Calculated value" or click on the button "[color:red]Specify" [color:blue]Next, type in, or select the Text Function to be use (or ganged) close the window, and besure to deselect the checkbox Do not replace existing value of the field (if any) Click [color:blue]Okay and leave the Manae Database if done. HTH Lee Edited February 11, 2010 by Guest Link to comment Share on other sites More sharing options...
Lee Smith Posted February 11, 2010 Author Share Posted February 11, 2010 Sorry about the double files, they really messed this up. Just go to the middle where the text starts, and ignore the jpegs at the top. Lee Link to comment Share on other sites More sharing options...
Newbies PedroAlexanderson Posted May 8, 2010 Newbies Share Posted May 8, 2010 Hi. Your solution es very nice, it's work wonderful to me. i'm do an adaptation, couse in Mexico, the phone's code not are the same in all the states. we have 3 states with prefix = 2 numbers (thank's God, only 3), the others have 3 numbers. (total = 989) and i have the archive in fm7, but i can't use it. then i use your example and make a Case routin. and after write a CF, wooooow, very nice aond powerfull again, thaks so much. (do you see, i dont speak english, but i'm sforce) please forget me Pedro Link to comment Share on other sites More sharing options...
Lee Smith Posted May 9, 2010 Author Share Posted May 9, 2010 Hi Pedro, and welcome to the Forum. I read your post the yesteday, but I didn't see a question in it. Are you asking for help? Lee Link to comment Share on other sites More sharing options...
Recommended Posts