If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Crosstab Report not previewing past first page
I have created a crosstab report where when you do a print preview Access
only shows the first page and doesn't activate the navigation buttons at the bottom of the print preview window so you can navigate to the rest of the pages. If you open and close the Page Setup dialog then the rest of the pages can be viewed. This happens in both Access 200 and 2003. More info about the report: the column headers and controlsources of the controls in the detail section are dynamically set as is the report width. Some controls are also hidden if they are not needed. In the report footer some of the textboxs have their controlsources set to a constant value. The datasource is a temporary table that is created from the results of the crosstab. Any ideas how I can fix this bug? Thanks Simmy |
#2
|
|||
|
|||
Crosstab Report not previewing past first page
Consider creating crosstab reports based on the samples at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4. The Crosstab.mdb has a solution that might use much less code and display faster. -- Duane Hookom MS Access MVP -- "Simmy" wrote in message . com... I have created a crosstab report where when you do a print preview Access only shows the first page and doesn't activate the navigation buttons at the bottom of the print preview window so you can navigate to the rest of the pages. If you open and close the Page Setup dialog then the rest of the pages can be viewed. This happens in both Access 200 and 2003. More info about the report: the column headers and controlsources of the controls in the detail section are dynamically set as is the report width. Some controls are also hidden if they are not needed. In the report footer some of the textboxs have their controlsources set to a constant value. The datasource is a temporary table that is created from the results of the crosstab. Any ideas how I can fix this bug? Thanks Simmy |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
page number printing on a merged report | Print Page # On Merged Report | Mailmerge | 6 | October 17th, 2005 05:18 AM |
Printing Reports Access 2002 Pleas Advise | Dermot | Database Design | 12 | October 5th, 2005 11:23 AM |
REPOST: Maintaining Page Numbers with multiple reports. | Robin Chapple | Setting Up & Running Reports | 1 | August 5th, 2005 06:53 AM |
report sometimes prints final blank page (except for page header) | John S. Ford, MD | Setting Up & Running Reports | 3 | December 11th, 2004 11:50 AM |
report sometimes prints final blank page (except for page header) | John S. Ford, MD | General Discussion | 1 | December 11th, 2004 10:28 AM |