aldipalo Posted February 25, 2006 Share 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 Link to comment Share on other sites More sharing options...
Lee Smith Posted February 25, 2006 Share 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 Link to comment Share on other sites More sharing options...
Oldfogey Posted February 26, 2006 Share 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? Link to comment Share on other sites More sharing options...
Genx Posted February 26, 2006 Share 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 Link to comment Share on other sites More sharing options...
aldipalo Posted February 26, 2006 Author Share 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 Link to comment Share on other sites More sharing options...
ajnhlr Posted May 15, 2006 Share 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 Link to comment Share on other sites More sharing options...
aldipalo Posted May 15, 2006 Author Share 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? Link to comment Share on other sites More sharing options...
Genx Posted May 15, 2006 Share 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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6567 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