Tab Control

[depawl]

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]

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.

 

[Rich]

Putting a tab control; on a Report is pointless, what would you expect it to do?

 

[depawl]

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.

 

[Rich]

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]

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]

Simply don't use Tabs. They are for Forms not Reports.

Place all your charts in sub Reports.

 

[depawl]

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]

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]

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.