Switching the sign of a text box value on a report

[Bill Singh]

Hi All - i have a textbox in a report that has a negative value but i would like to display it as a positive value. In other words i would like to change the sign on the report but not in the underlying query. Below is what i have



Current text in the textbox: Sumof2014Month

I tried: =[sumof2014Month] * -1

Result: Error message "Invalid Control Property: Control Source and Circular Reference.

Can someone please suggest the correct format/method of doing this? Thanks.

[June7]

Try Abs() function.

Make sure controls do not have same name as field referenced in their ControlSource expression.

Change name of the textbox to something like: tbxSum2014

[Bill Singh]

The issue was relating to the textbox name and the underlying control source being the same. Many thanks.