Comma wont appear in text box value.

[PuddinPie]

Hello all,

I have a text box that has an iif statement in it and a referenct to a numerical value that is suppose to be a currency.

The table that is providing the source for the report show the value as $x,xxx.xx and if a create a text box with just it in the report it shows as $x,xxx.xx but when I put it into the iif statement it shows as $xxxx.xx with no comma.

iif statement example in txtbox:

=iif([Happy]=true,"I am happy with " & [value] & " in profits","I am sad with " & [value] & " in profits")

[value] is suppose to be like $1,111.11 but instead their is no comma showing $1111.11.

Any help would be great.
Thank you.

 

[CJ_London]

try using the format function

& format([value],"currency") &
or
& "$" & format([value],"0,000.00") &

 

[PuddinPie]

Thank you. format([value],"currency") worked perfectly.