There is a value that is being pulled from my database which is 41428.57. When formatting it using the above example ({Replace(Format("{0:C}", quoteTable.projTotal), " ", ",")}) it spits out $41,428.56 (a penny less than what the total should be). I figured this might have something to do with the decimal rounding of the value pulled from the MySQL database so I tried it hard coded by doing this:
({Replace(Format("{0:C}", 41428.57), " ", ",")}) and lo and behold it STILL formats it as 41428.56. How does that happen? And the weird part is it doesn't do that with *every* number so it may be a tough bug to track down.
Here are a couple of screenshots and an example report.
This really puts us in a bind since the currency formatting isn't working like expected and the only workaround we have isn't working like expected either. hehe Hopefully you guys can get this fixed. Thanks.
