depawl
10-16-2009, 06:44 PM
I have an Access report with several pages that I have setup up using the Tab Control. When I try to Preview the report, all I can see is the first page, irregardless of which tabbed page that I have selected in Design View. I Googled the problem and found that this behavior is by desing in Access 2000 and 97, so I assume that it's the same in 2003? It just seems strange that I can't preview the rest of the report's pages prior to printing.
Any assistance is most appreciated.
Kryst51
10-16-2009, 09:36 PM
Do you mean you have a form with several tab controls? And when you select print preview on the form you only see one page?
If this is the case, I suggest building an actual report. Build a query that has your fields in it, base the query parameters on the form, then have a button on your form, or multiple for different forms to open your form in print preview.
Putting a tab control; on a Report is pointless, what would you expect it to do?
depawl
10-17-2009, 03:18 AM
As I said initially I have a report (not a form) that is several pages in length. It contains responses to a consumer survey. There are 40+ questions on the survey and the report has a pie chart that breaks out the percentage of responses to each question, as well as a text box for consumer comments to each question. This format has been dictated by my agency's management. I can only fit 2 of these responses (chart plus comments) on each page. So I have setup tab control for the individual pages, and will eventually have a report that is 20 +/- pages in length. I can see everything in design view, but when I print preview only the first page is visible. I would like to be able to preview the other pages before printing.
Thanks.
You can't preview the other pages because they are not there, Reports do not work in the same way as forms, try moving the Chart to the Report header
depawl
10-17-2009, 07:00 PM
Rich:
I will need to have several charts in this report, maybe 30 or so. So I can't move them all to the header. I need to be able to have a report that is 30 +/- pages long. Surely there must be a way to do this in access?
RainLover
10-17-2009, 07:31 PM
Simply don't use Tabs. They are for Forms not Reports.
Place all your charts in sub Reports.
depawl
10-18-2009, 04:52 PM
RainLover:
Thank you. This appears to be working out ok so far. Is it reasonable to presume that I could create a 20 +/- page report in this manner, or is that more than access can handle? The survey that this report is based on has 40 questions, and there has to be a chart and a "comments" text box for each question, so the report would need to have 80 subreports.
RainLover
10-19-2009, 01:29 AM
This link may be of help.
http://office.microsoft.com/assistance/hfws.aspx?AssetID=HP051868081033&CTT=1&Origin=EC010227011033
80 Sub Reports does worry me.
Please feel free to contact me when you run into problems.
depawl
10-19-2009, 03:06 AM
OK, I appreciate it. I'll keep on going and let you know how I make out. I may consider breaking the report into 4 or 5 smaller reports.