I'm using this calc for my Phone Number custom function. I got this either off this site or CC support forum. Everytime I enter a number I get an error message. I then re-input the same number and it works fine.

Case

(IsEmpty ( Phone Number );" ";

Length(Phone Number) = 7;Left(Phone Number;3) & "-" & Right(Phone Number;4);

(Length(Phone Number) = 10); "(" & Left(Phone Number;3) & ") " & Middle(Phone Number; 4; 3) & "-" & Right(Phone Number;4);

"Wrong number format")

Can anyone tell me what's wrong?

Thanks,

Al

Edited February 25, 200619 yr by Guest

I just tested this as a calculation and it works (it should work then as a CF)

is your field TEXT result, and is it big enough to show the results. (i.e. if you see a ? in there, then it needs to be widen.

HTH

Lee

I take it you are putting the result back in the Phone Number field? If so, have a look to make sure your field is really empty when you start entering data.

Why do you set it to a space when it is empty?

What exactly is the error message? And i think it may or may not have to do with your space when its empty like Oldfogey suggested.

~Genx

As I stated I copied this from either this forum or CC forum. I deleted the space from the calc and it seems to work fine now.

Thanks for all your input.

Edited February 26, 200619 yr by Guest

When I copy and paste this calculation and try to enter data I get a dialog box telling me the field is not modifiable. What am I doing wrong?

FM 8 advanced on Mac 10.4.6

Did you set it up as a Custom Function or simply a calculation within a field? Is the field set as text? Can you post a copy/clone of your file or show us pictures of your field set up?

Your field should be a text field (or anything thats not a calc or summary) with auto enter calculation checked (with your custom function calc in here) and do not replace contents unchecked.