Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Location
    Hong Kong
    Posts
    29

    Red face Unanswered: ACCESS 2002 Printing Report

    I am modifying a report, some records are retrieved in the Detail section, there is a field called amount. If amount = 0, I have to skip that record, I can make that record invisible but there is some space left. I just want to make no space left. Can somebody help?

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713

    Re: ACCESS 2002 Printing Report

    Originally posted by cchan
    I am modifying a report, some records are retrieved in the Detail section, there is a field called amount. If amount = 0, I have to skip that record, I can make that record invisible but there is some space left. I just want to make no space left. Can somebody help?
    In the Detail_Format method of the report put a test for the amount and if it's 0 just cancel...
    Example:
    Code:
    Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
        If amount.Value=0 Then
            Cancel = 1
            Exit Sub
        End If
    
    End Sub

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •