Change format of sting field

[mroos81]

Hello
I've the following problem:
When I add a character to a numeric field in a formula field it becomes a String field.
( example: 'X'+ToText ({Table.Field_ID}) )
I don't want the Field_ID to have a thousands separator, but because I changed it to a String field, it isn't possible to change it anymore.

Is it possible to delete the point from the formulafield?

 

[dgillz]

Try this:

"X"+ToText({Table.Field_ID},0,"&quot


Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com