A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

totals do not display unless user clicks on text box



 
 
Thread Tools Display Modes
  #1  
Old May 26th, 2010, 05:01 PM posted to microsoft.public.access.gettingstarted
nickname[_2_]
external usenet poster
 
Posts: 2
Default totals do not display unless user clicks on text box

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
  #2  
Old May 27th, 2010, 05:30 PM posted to microsoft.public.access.gettingstarted
KenSheridan via AccessMonster.com
external usenet poster
 
Posts: 1,610
Default totals do not display unless user clicks on text box

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 wrote:
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


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...arted/201005/1

  #3  
Old May 28th, 2010, 02:28 PM posted to microsoft.public.access.gettingstarted
nickname[_2_]
external usenet poster
 
Posts: 2
Default totals do not display unless user clicks on text box

On May 27, 12:30*pm, "KenSheridan via AccessMonster.com" u51882@uwe
wrote:
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 wrote:
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


--
Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/20...


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
  #4  
Old May 28th, 2010, 04:48 PM posted to microsoft.public.access.gettingstarted
KenSheridan via AccessMonster.com
external usenet poster
 
Posts: 1,610
Default totals do not display unless user clicks on text box

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

nickname wrote:
On May 27, 12:30 pm, "KenSheridan via AccessMonster.com" u51882@uwe
wrote:
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]
--
Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/20...


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


--
Message posted via http://www.accessmonster.com

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:42 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.