PTKen Posted April 19, 2007 Share Posted April 19, 2007 Hello. I have a text field. I also have a calculation field whose result is the text of the text field. On my layout I display the calculation field so that the field can be scrolled, but not edited. My problem is that I have noticed some fields that contain certain text that causes the calculation to give a numeric result instead of the text. For example, if the text field contains the following text: Evaluate and optimize ICC profiles for the Creo EverSmart scanner (for scanning transparencies) to achieve the best possible visual match between monitor and transparency when viewed under ISO/DIS 12646:2002(E) conditions (Annex A section A.1). then the calculation field displays: 126462002 However, if I click on the calculation field, the original text shows up until the field is no longer active. I'm pretty sure it's the colon causing the problem, but I don't know how to solve it. Restricting the use of a colon is not an option as this will likely come up a lot. Any ideas around this? Link to comment Share on other sites More sharing options...
mr_vodka Posted April 19, 2007 Share Posted April 19, 2007 You need to change your calculation to have a text result. Right now it is a number result. Link to comment Share on other sites More sharing options...
PTKen Posted April 19, 2007 Author Share Posted April 19, 2007 No, I checked that. The calculation is a text result. I also didn't make it clear that most fields do display correctly, it's only ones with certain characters (I think the colon is part of the problem) that do not display properly. Link to comment Share on other sites More sharing options...
mr_vodka Posted April 19, 2007 Share Posted April 19, 2007 When I copy your text and put it into a text field and then create a calc that references that with text result, it displays fine. However, if I change it to a number result, it will do exactly as you have described. It will display 126462002. When you click in the field it will show it all. Have you tried creating a new text and calc field or new file to seeing if it does it there as well? Are you on the latest patched version of 7? Link to comment Share on other sites More sharing options...
PTKen Posted April 19, 2007 Author Share Posted April 19, 2007 Thank you for testing it. You were both correct, it was set as a number result. When I checked it, I checked the wrong table (I have a similar set of fields on another table with a similar name). Sorry for the noise and thanks again for the help. Link to comment Share on other sites More sharing options...
mr_vodka Posted April 19, 2007 Share Posted April 19, 2007 Both? Uhmmm I dunno about you but I only saw 2 people in here... lol. Just teasing ya. Glad that it worked out for you. Link to comment Share on other sites More sharing options...
PTKen Posted April 19, 2007 Author Share Posted April 19, 2007 Oops! Yeah, it's been one of those days. ;) Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6216 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