How to make an expandable table to hide/show details of a report?

B

BY

Is it possible to make a table report with an expandable tab that hide or
show the details? Thank you.
Brad
 
M

Marshall Barton

BY said:
Is it possible to make a table report with an expandable tab that hide or
show the details?
Click to expand...


No. Reports are printed to sheets of paper where buttons,
tabs, etc have no effect. Any other output of a report
(Preview, PDF, etc) are just electronic representations of
the paper so that is not an alternative.

In general, you need to close the report and reopen it with
some other option that hides the details.

The one trick I know of is if you use a custom menu/tool bar
(or even a form) button, you can get a report in preview
mode to redo itself by setting its OrderBy (or Filter)
property:
'show/hide detail
Reports!thereport.Section(0).Visible = <some condition>
'redo report without closing and reopening
.OrderBy = """xxx"""
.OrderByOn = True
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Printing Subdatasheets within Main datasheets 0
Create form with checkbox les that expand and collapse sections of the form? 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Access 2002 change report header text 0
Report Page Header and detail fields link to adjust automatically in Access 2007 2
memo field expansion in details section of report? 1
How to have two tables on same line? 1
Insert Index into a Table 1

Top