MS Access 2019 desktop report Print View issue.

[mgalvinjr]

MS Access 2019 desktop 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:

[june7]

I tested this arrangement and my textbox shows 0 when subreport does not have records.

Might attach your db to post for analysis.

[spiceuser-t7sgg]

Try to add NZ

Nz(Adjustments  =[Child5].[Report]![GLAdjustmentTotal],0)