Hi Rory,
I wish there was a way to format the text easily without the commas, but this is an unfortunate side-effect of the Crystal 4 engine.
You have to edit out the comma manually using a formula. Because the year will always be 4 digits (at least for the next 8000 years
), you want to take the 1st and the 3rd through 5th characters of the generated text field:
ToText(2001,0)[1]+ToText(2001,0)[3 to 5]
This will create the text string '2001'.
Even this is an easier example, where the number of digits is known. It can be done for amount fields where the amount (and therefore the position of the commas) is variable, but very complicated.
Regards,
Softrak Support