>how about something like:
>
>IIF(ABS(report1.total)>10,report1.total,-1)
>
>
>>I currently have a grid and in one of the columns is the control source of ABS(report1.total). Now the file actually reflects a negative and since the grid is eyecandy, it does not change - as you know. Now. I have this other column with a checkbox. When the user clicks on the checkbox, I would like for the column showing the ABS to actually reflect the database value just for this line item. Is this possible?? So when clicked it would show a negative. If the database showed a postive, the column would go unchanged. Thanks in advance@@
Unfortuanely that will not work. The problem being is that when the user enters the form, the grid must reflect the ABS(report1.total) in column3. Thus while the user is using the program, if they want to see the real value, they just click on the checkbox to see the real value of that particular line item. I attempted to change the ControlSouce Value which currently is: ControlSouce=ABS(report1.total).
However, when I did that, the system elimated the numbers.
