Forum Discussion

malcolm_p_galvin_jr's avatar
malcolm_p_galvin_jr
Copper Contributor
Aug 22, 2023

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:

 

 



 

No RepliesBe the first to reply

Resources