aldipalo Posted February 25, 2006 Posted February 25, 2006 (edited) 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, 2006 by Guest
Lee Smith Posted February 25, 2006 Posted February 25, 2006 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
Oldfogey Posted February 26, 2006 Posted February 26, 2006 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?
Genx Posted February 26, 2006 Posted February 26, 2006 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
aldipalo Posted February 26, 2006 Author Posted February 26, 2006 (edited) 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, 2006 by Guest
ajnhlr Posted May 15, 2006 Posted May 15, 2006 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
aldipalo Posted May 15, 2006 Author Posted May 15, 2006 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?
Genx Posted May 15, 2006 Posted May 15, 2006 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.
Recommended Posts
This topic is 6783 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now