Mask Fields

[John Chamberlain]

I have a file that has phone numbers formatted like this: 919/213-4567. A long time ago I found a tip that allowed me to paste the number into the field, with a calculation field on top of the actual phone number field. The calculation field then showed the number correctly formatted as (919) 213-4567. I have used this many times before, and it has always worked fine.

Today, even though I had pasted in several numbers successfully, I suddenly encountered a message stating that the field (the mask on top of the actual number) could not be entered because it was not modifiable. I know that I cannot modify a calculated field, but why did this suddenly become an issue?

[John Chamberlain]

This might help - I have attached a file that has phone number fields that DO work. The file I am having trouble with is far to large to attach here.

UNtitled_Converted.zip

[Lee Smith]

I see you are using v9 now. That trick isn't needed in v9, you can use one of the Auto Enter methods that has been discussed many times in the past.

I would verify that the order of the fields are Raw Data bottom, allow entry, calculation on top, allow entry [color:red]deselected,

In version 9, create your phone number field, use the options for text, Auto Enter such as used by Søren in this attachment Link

If you need to change existing data, we had a recent discussion on this; Link

HTH

Lee