June 19, 2012 at 6:46 am
I do not want commas if the number is above a thousand, but this does not even give me the decimals.
I need it to look like 12345.23
=iif(reportitems!Avail_IN.Value - reportitems!Avail_Out.Value <=0,"$" & FORMAT(reportitems!Avail_IN.Value - reportitems!Avail_Out.Value, "######.##")
June 19, 2012 at 2:03 pm
Did you try the Number property for the Text Box? Right click in text box and select Text Box Properties. On the Number pane, select Number or Currency in the Category field. (Currency if you want the money symbol). Set the decimal places and the 1000 separator value.
I'm pretty sure this won't work if the value is not a numeric, at least I haven't had any luck formatting strings even with the conversion functions.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply