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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|