totals do not display unless user clicks on text box

[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

 

[KenSheridan via AccessMonster.com]

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

 

[nickname]

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.

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

Thanks

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

 

[KenSheridan via AccessMonster.com]

Double clicking in the report object in Access 2007 opens it in 'Report View',
which is just a continuous layout of the report. I tried opening one of my
own reports, which includes a summary total in a group footer, in this way
but couldn't reproduce the behaviour you are experiencing; the summary total
showed immediately. I'm therefore at something of a loss to explain the
behaviour or a remedy, I'm afraid.

Ken Sheridan
Stafford, England

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

[quoted text clipped - 23 lines]
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