In Report View unbound text boxes display calculation correctly. When switched to Print View the text boxes do not display the calculation correctly: e.g. #Size! or #Type!. Do not understand why. HELP!!
Design: I have a report, Report_GeneralLedger. The reports source is: SELECT Account.AcctID, Account.Account, Account.Fund FROM Account; There is a text box for AcctID, Account and Fund.
There are also the following unbound text boxes: Assessments Control Source =[Child2].[Report]![AssessmentTotal] InterestIncome =[Child4].[Report]![InterestIncomeTotal] Adjustments =[Child5].[Report]![GLAdjustmentTotal] Disbursements =-[Child6].[Report]![DisbursementTotal] BALANCE =Nz([Assessments])+Nz([InterestIncome]) +Nz([Adjustments])+Nz([Disbursements])
There are 4 subreports referred to in the control sources, above for the text boxes.
The form has only one Event associated with it and its controls: Private Sub Report_Open(Cancel As Integer) If CurrentProject.AllForms("Form_OpenAccount").IsLoaded = True Then DoCmd.Close acForm, "Form_OpenAccount" End If End Sub
Report View: The 5 text boxes listed above display the Total from their respective subreports. If there is no activity, the text box displays a -0-. The subreports are displayed even if there is no activity.
Print View: When there is no activity the Child subreport without activity is not displayed and the related text box displays an error. Is there a way to fix this?
I wouldn't rely on getting values from a subreport like that. Calculate them on an open form or in memory. Perhaps use domain aggregate functions like Dsum.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.