Currency Format

[Gismo]

Hi all,

Any reason why my value control wont format to currency with thousand separator and no decimals?
The data type is number, double

"UGX "#,###;"(UGX "#,###)

 

[CJ_London]

what does it format to?
and what is the currency setting in windows?

 

[Gismo]

what does it format to?
and what is the currency setting in windows?

It formats to 2553440 instead of 2,553,440 (Original value 2553440.23)
I don't want to see the decimals so that is correct

Window currency is set to ZAR, don't want to change that

 

[CJ_London]

works OK for me - i just copied your format string
for values 123456.78 and -123456.78

so suggests there is something in your settings preventing it from formatting as you require - don't ask me what, I have no idea

 

[Cotswold]

On the Property Sheet for Form or Report try setting Format to Currence or Fixed and set the decimal places to 2

 

[Gismo]

On the Property Sheet for Form or Report try setting Format to Currence or Fixed and set the decimal places to 2

When I set the format to currency and decimal 2, I do get R4 424 200,00
Even when I set the decimal to 0, still the correct output as I dont want to see decimals
Which looks good but the incorrect currency
I dont want to change the windows currency tp UGX though

 

[Pat Hartman]

If you don't want to change the windows currency symbol, then use a separate field for the symbol and format the numeric value as fixed. That will always keep the currency symbol far to the left which is the preferred format for accountants. I keep the data in a currency field to avoid floating point errors but don't confuse the currency data type with the currency format.

 

[gemma-the-husky]

Why "UGX "#,###;"(UGX "#,###)

Is that correct, including the #,### ? I don't know, just asking, but is that how you specify a thousand's separator?

 

[Gismo]

Thank you all,

It works

Removed the , and replaced with space

"UGX "# ###;"(UGX "# ###)