custom currency formatting

  • Thread starter Thread starter bartas008
  • Start date Start date
B

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
 
bartas008 said:
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!
Click to expand...


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

=Replace(Replace(Replace(Format(MyValue;"#.##0,00");".";"]");",";".");"]";",")
 
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

???




Marshall Barton said:
bartas008 said:
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!
Click to expand...


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

=Replace(Replace(Replace(Format(MyValue;"#.##0,00");".";"]");",";".");"]";",")
Click to expand...
 
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


Marshall Barton said:
bartas008 said:
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!
Click to expand...


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

=Replace(Replace(Replace(Format(MyValue;"#.##0,00");".";"]");",";".");"]";",")
Click to expand...
Click to expand...
 
Back
Top