Can I Format the number value of a parameter?

[ericb1]

I have a parameter set up as Discrete, multiple values. And the field on my report is formatted to plain numbers, no commas, no currency, etc. But for some reason when it's creating the list of parameters to search for, it's formatting them as a currency.

So I enter 12345 as a criteria, and it lists it as 12,345.00 Is there any way to control this formatting? It's not matching any criteria and I think this may be a problem.

Any help is appreciated, thanks!

 

[Turkbear]

Hi,
If the field is is comparing against is a Number, then
12345 is the same as 12,345.00 and should not be a problem.

I have not found a way to have CR format the parameter.







To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Madawc]

Try File>Options>Fields> Currency. That should show your default, presumably commas and two decimal places for anything.

Madawc Williams (East Anglia, UK)