Hi
What does this error mean?
Any advise on how to fix? Am just adding a zero to the front of 7 digit codes.
Had no issue with this similar function below.
thanks
Solved! Go to Solution.
Hi @BillyL14
It would seem that [Code number2] is a numeric-type field. To use the value of this field as a string (so it can be combined with other strings) you can apply a conversion to the value in the formula. You could add the ToString( function to the field reference like this: ToString([Code number2]) and the expression will be valid.
However, if the field is numeric, and even if you make the expression work, the resulting string will not be able to go back into the numeric field. You could assign this expression to a new field, change the field type of [Code number2] ahead of time, or use a Multi Field Formula tool to apply the expression and change the field type in one tool.
thanks