[RESOLVED] [2005] Changing the format of a number field in Crystal Report (again!)

Hi

This is linked to a previously resolved thread that I posted. (http://www.vbforums.com/showthread.p...10#post2629010)

Basically I have hardcoded parameter field that is a year e.g. 2004, with hardcoded values. I've tried setting it up as a Number so that I can manipulate it as a number in the Record Selection Formula e.g. 2004 + 1. The problem I'm having is that the Parameter Field Editor converts 2004 to 2,004.00!

In the previous thread, bmahler kindly gave me an answer to use the custom format to force the parameter to be something like 2004. I did this and it worked in the report preview. But I have just tried running it through my application and it is showing up as the 2,004.00 format again!!! Any ideas anyone?

I've found the answer elsewhere, the formula to use is ToText({fieldname},0,"")