Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Tue Aug 28 12:36:31 CDT 2007
It sounds like you need to add a grouping level, if it's not already there, and then add the header and the footer. In the footer you drag the page break control from the report design toolbar and drop it into the footer. So it will page break on that group level. In the format event of the header for that group, ask if this is the group that you want to break on. If so, make the page break control visible, if not make it invisible. Clear as mud? Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence Sent: Tuesday, August 28, 2007 9:07 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Force a new page in code Hi Rocky: How is that control setup? Is it a group, a command or a piece of code? A client has a fairly straight forward report but at times wishes to have a certain group start at the top of a new page. I can think of certain long clumsy methods to do this but there must be some eloquent method like: Me.page.newpage < this is just pseudo code TIA Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at Beach Access Software Sent: Tuesday, August 28, 2007 5:02 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Force a new page in code Jim: There's a page break control which I have made visible and invisible programmatically during report generation, depending on whether I want it active. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence Sent: Monday, August 27, 2007 11:19 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Force a new page in code Hi all: Is there a way to force a new page in Access reports under program control? TIA Jim -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.484 / Virus Database: 269.12.10/976 - Release Date: 8/27/2007 6:20 PM -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.484 / Virus Database: 269.12.10/976 - Release Date: 8/27/2007 6:20 PM