Format function

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Use syntax like:
Format([YourField],"#,##0")
and
Format([YourField],"#,##0.00") or Format([YourField],"Standard")
 
Back
Top