ACC2: RunningSum Text Box in Report Not Accumulating Values

MORE INFORMATION

This problem is usually encountered in databases that have been converted from version 1.x to 2.0.

Steps to Reproduce Problem

1. Start Microsoft Access and open the sample database NWIND.MDB.
2. Create a new report based on the Products table.
3. Add two new text boxes side by side to the report's detail section. Note that the Name property of the left text box is Field0, and the right text box is Field2.
4. Set the following properties for the text boxes:
   

         Name: Field0
           ControlSource: =[Unit Price]
   
         Name: Field2
           ControlSource: =[Field0]
           RunningSum: Over All
   						

5. Preview the report and scroll to the last page.

Note that the Field2 text box reflects only what is contained in the Field0 text box, even though its RunningSum property is set to Over All. It does not accumulate the values contained in the two text boxes as it should.

To correct this problem for fields in the underlying record set, set the Field2 text box's ControlSource property to

   =[Unit Price]
				

or use the Val() function as in the following example:

   =Val([Field0])
				

Note that this does not correct the problem for expression fields such as DLookup() and Sum(). You can also try placing the expression in the underlying query or incrementing a global variable using Access Basic.