totals do not display unless user clicks on text box

  • Thread starter Thread starter nickname
  • Start date Start date
N

nickname

I am relatively new to access. I am using access 2007 to create a
report that contains subtotals. When the report is displayed on the
screen the subtotals are blank. When the user clicks on the subtotal
text box then the value appears. The user has to click on each
subtotal in order to make the value appear.

Has anyone experience this problem? Is there a workaround or
solution?

Thanks
 
Normally a sub-total in a report is achieved by means of an unbound text box
in a group footer with a ControlSource property which is an expression
summing a set of values from the detail section, e.g.

=Sum([SaleAmount])

The sub-totals should then show automatically when the report is opened in
print preview or sent to a printer.  Is yours set up  in this way?  Also is
there any code in the text box's Click event procedure; or any other of its
procedures for that matter?

Ken Sheridan
Stafford, England
I am relatively new to access.  I am using access 2007 to create a
report that contains subtotals.  When the report is displayed on the
screen the subtotals are blank.  When the user clicks on the subtotal
text box then the value appears.  The user has to click on each
subtotal in order to make the value appear.
Click to expand...
Has anyone experience this problem?  Is there a workaround or
solution?
Click to expand...
Thanks
Click to expand...
Click to expand...

Ken, thanks for the reply. It is set up as you describe: an unbound
textbox placed in the "group on" section of the report
=Sum([AmountToBill]) and there is no code in any of the text box
events.

It is interesting to note that the printed and print preview versions
of the report are fine. However, when I open the report (double click
on the report name in the left pane) it does not display the totals
(just blank space). The totals only appear if I click on the location
(textbox) where they should normally appear.

Thanks
 
Back
Top