>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@@
How about adding a second textbox to that column, which would have the raw controlsource - without the abs(). On checkbox just flip the .dynamiccontrol property of that column to use one textbox or the other one.