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, 201015 yr by Guest

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

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

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