Access report mask

[taino]

Hello, I have a MS Access report, in this report, I need format output textbox with mask "RD$"#.##0,00 but now if I have decimals values it ouput correct for example: (1.000,12 output RD$1,000.12) but if value dont have decimals values it dont put .00
example if value is 1000 output is RD$1,000 but I need output RD$1,000.00







the source data value is a query, I try format data in a query but I have the same results.



Thanks for your help

[ranman256]

Set the properties:

decimals: 2

[taino]

Hi ranman256,

thanks, I try but have the same result

Regards