Jump to content

Simple Calc-Script Help


This topic is 2316 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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:

01.png.4002acad2f7af881a81701d20dda4d67.

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

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 :beer:

Phil

Link to comment
Share on other sites

This topic is 2316 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.