Philip Curtis Posted February 25, 2016 Share Posted February 25, 2016 Hello, I have this Calculation script: Address_Mailing1 & " " & Address_Mailing2 & " " & "¶" & City_Mailing & ", " & " " & State_Mailing & " " & "¶" & Country_Mailing & " " & ZipCode_Mailing which is successfully combining multiple address fields into one field so I can cut/paste out of FM easily, except for one problem. When I use this script and enter only one zip code number (3 for example) I get this result: 411 Teal Street, No. 1773 Green Cove Springs, Florida United States of America 3 But with the same script and a full zip code (33316 for example) I get this result: But if I click on this field, it changes to the correct output and I can copy it like so: 411 Teal Street, No. 1773 Green Cove Springs, Florida United States of America 33316 So the question is, why is this field displaying only the combined address field numbers and only with more then one zip code digit, and isn't displaying the correct results? Thanks, Phil Link to comment Share on other sites More sharing options...
Lee Smith Posted February 25, 2016 Share Posted February 25, 2016 calculations default to a numbers. Change the results and text or the Field is too small for the display of the calculation.. Link to comment Share on other sites More sharing options...
siroos12 Posted February 25, 2016 Share Posted February 25, 2016 I am agree with Lee. 1 Link to comment Share on other sites More sharing options...
Philip Curtis Posted February 25, 2016 Author Share Posted February 25, 2016 Change the result 17 hours ago, Lee Smith said: calculations default to a numbers. Change the results and text or the Field is too small for the display of the calculation.. Change the results to Text, that must be it because the field space is bigger then the text. Thanks again Lee. Seems like you're a pretty sharp fella Phil Link to comment Share on other sites More sharing options...
Philip Curtis Posted February 25, 2016 Author Share Posted February 25, 2016 Just got it. Thanks, Phil Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3117 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