Forum Discussion
MS Access 2019 desktop version report Print View issue
MS Access report Print View issue.
In Report View unbound text boxes display calculation correctly. When switched to Print View the text boxes do not display the calculation correctly. Do not understand why. HELP!!
Report View:
Print View:
Design:
I have a report, Report_GeneralLedger. The report’s 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.
Example 1 – each Child subreport has activity:
Example 2 – not all Child subreports have 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?
Example 1:
Example 2: