Format Currency as - $4.321.09 Instead of ($4,321.09)

[Guest]

Is that easily done?

I prefer the ($4,321.09), but the User wants - $4.321.09.

TIA - Bob

 

[Guest]

Mybe there is a better way, but you can alway use the Replace function


Replace(Format([FieldName],"#,###.00"),",",".")

 

[Guest]

Ofer - Thank you.

I just tried this, but it isn't working.

Bob

Mybe there is a better way, but you can alway use the Replace function


Replace(Format([FieldName],"#,###.00"),",",".")


--
Good Luck
BS"D

Is that easily done?

I prefer the ($4,321.09), but the User wants - $4.321.09.

TIA - Bob

 

[Douglas J. Steele]

What have you specified as the Format property for the field or control?

 

[Guest]

Doug - Currency...

But I just found an old Post from 2001...

I've asked this before, but nobody answered.
I'm trying to format my currency fields to look like Excel's accounting
format:
$44.66
$1,244.66

ANS=Add an Unbound Text box to the report.
Set it's Control Source to:
=IIf(IsNull([CurrencyField],"","$")
Size it to an appropriate width.

Then place the [CurrencyField] control to the right of the label.
Set the Format of the control to Standard and the Decimal to 2.
Make sure the [CurrencyField] control is Right-aligned and that it is
wide enough to display the largest expected number.

This will display the $ only if the currency field has data.

I'll try the above.

Thank you - Bob