Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Feb 2002
    Posts
    537
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Collapse the report (Access 2000)

    I have a report in table design and the first textbox in the row is productid, etc. The rows in my reports are shown blank, since there is no productid, but there are some other textboxes in the row showing some figures. Is it possible not to show any rows where the productid is not shown ? I have made the Shrink properties to yes also in the design view, but it doesnt help.
    Just to add, actually the rows are blank, but are shown.So my question is how to hide the blank rows

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Collapse the report (Access 2000)

    You could create a query that selects the records for which ProductID is not Null, and use that query as record source for the report.

Posting Permissions

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