Format function

[Guest]

Hi all,

I have a field in my report which i want to format differently depending on
type of currency it shows (if it shows VND - then decimal places =0, if USD -
then decimal places =2)

somehow my code below doesnt work
it shows correct numbers but always formats them with decimal places = 2

can somebody help me please??

=IIf([VND]=True,(Format$(([BA-176-VND]*-1),"Standard",0)),(Format$(([BA-176-USD]*-1),"Standard",2)))

Thank you.
Lana

 

[Duane Hookom]

Use syntax like:
Format([YourField],"#,##0")
and
Format([YourField],"#,##0.00") or Format([YourField],"Standard")