Simple Calc-Script Help

[Philip Curtis]

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

 

 

 

[Lee Smith]

calculations default to a numbers. Change the results and text or the Field is too small for the display of the calculation..

[siroos12]

I am agree with Lee.

[Philip Curtis]

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

[Philip Curtis]

Just got it.

 

Thanks,

Phil