custom currency formatting

[bartas008]

hey please help me!
i have to display fields on my report in Danish currency format.
But only for single report in my application so i don't want to change
windows regional settings.
Danish format is : 123.093,00 or 26,00 - examples
i try something like this: =format(MyValue;"#.##0,00) but access chane it
to #.0,00 automatically and currency is displayed incorrect!

i hope somebody help me

 

[Marshall Barton]

i have to display fields on my report in Danish currency format.
But only for single report in my application so i don't want to change
windows regional settings.
Danish format is : 123.093,00 or 26,00 - examples
i try something like this: =format(MyValue;"#.##0,00) but access chane it
to #.0,00 automatically and currency is displayed incorrect!

I would like to think there's a better way, but you can try
using:

=Replace(Replace(Replace(Format(MyValue;"#.##0,00");".";"]");",";".");"]";",")

 

[bartas008]

Thanks.
But the problem still is when i type :
=Replace(Replace(Replace(Format(MyValue;"#.##0,00");".";"]");",";".");"]";",")
ACCESS change it to:
=Replace(Replace(Replace(Format(MyValue;"#.0,00");".";"]");",";".");"]";",")

Why just i can't #.##0,00
it automatically change it to #.0,00

???

i have to display fields on my report in Danish currency format.
But only for single report in my application so i don't want to change
windows regional settings.
Danish format is : 123.093,00 or 26,00 - examples
i try something like this: =format(MyValue;"#.##0,00) but access chane it
to #.0,00 automatically and currency is displayed incorrect!

I would like to think there's a better way, but you can try
using:

=Replace(Replace(Replace(Format(MyValue;"#.##0,00");".";"]");",";".");"]";",")

 

[Marshall Barton]

Sorry, I should have changed your format to:
"#,##0.00"
so Access can understand it.

To use the format you were trying to use, you would have to
change your Windows regional settings.
--
Marsh
MVP [MS Access]

But the problem still is when i type :
=Replace(Replace(Replace(Format(MyValue;"#.##0,00");".";"]");",";".");"]";",")
ACCESS change it to:
=Replace(Replace(Replace(Format(MyValue;"#.0,00");".";"]");",";".");"]";",")

Why just i can't #.##0,00
it automatically change it to #.0,00

i have to display fields on my report in Danish currency format.
But only for single report in my application so i don't want to change
windows regional settings.
Danish format is : 123.093,00 or 26,00 - examples
i try something like this: =format(MyValue;"#.##0,00) but access chane it
to #.0,00 automatically and currency is displayed incorrect!

I would like to think there's a better way, but you can try
using:

=Replace(Replace(Replace(Format(MyValue;"#.##0,00");".";"]");",";".");"]";",")