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

B

Bob Barnes

Is that easily done?

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

TIA - Bob
 
O

Ofer Cohen

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


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

Bob Barnes

Ofer - Thank you.

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

Bob

Ofer Cohen said:
Mybe there is a better way, but you can alway use the Replace function


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


--
Good Luck
BS"D


Bob Barnes said:
Is that easily done?

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

TIA - Bob
Click to expand...
Click to expand...
 
B

Bob Barnes

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
 
Top