Format numbers in Pivot table form

[JayDee]

I have based a pivot table form on a Query With a calculatet Field for amount.



The amount filed is formatet as standard. In Norwegian this means something like this "# ###" A Space between thousands and hundreds.

In the form I can not format the amount Field to show the Space between thousands and hundreds.
I have tried put "Standard" in design wiew for the amount Field, but it still is shown without the Space.

Any idea what i can do?

[pbaldy]

It sounds like the calculated field may be seen as text. What is the calculation? Can the Format() function be added to it to force the format there?

[JayDee]

I just found out.
In the Pivot table I mark the amount field, then press the Property button on the ribbon. I can now format the Amount field

[pbaldy]

Glad you got it sorted.