Rocky Smolin - Beach Access Software
bchacc at san.rr.com
Tue Apr 12 10:45:56 CDT 2005
Charlotte:
No page breaks. Three sub-reports in the detail section.
I have the following events :
Private Sub Detail_Format
Private Sub Detail_Print
Private Sub GroupFooter0_Print
Private Sub Report_NoData
Private Sub Report_Open
Private Sub ReportFooter_Format
Private Sub ReportHeader_Format
The format events mostly stick things into text boxes. I do have :
Me.MoveLayout = False
Me.NextRecord = True
Me.PrintSection = False
Exit Sub
in a couple of places which get triggered on certain conditions.
Any clues there?
Thanks and Regards,
Rocky Smolin
Beach Access Software
http://www.e-z-mrp.com
858-259-4334
----- Original Message -----
From: "Charlotte Foust" <cfoust at infostatsystems.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Tuesday, April 12, 2005 8:25 AM
Subject: RE: [AccessD] Strange Report Page Numbering
> Does it actually print two pages or just one? I have seen this, but it
> has been caused by several different things, so you need to fill in the
> blanks for us. Do you have any physical page break in the report? Do
> you have any formatting that breaks before or after a section?
>
> Charlotte Foust
>
>
> -----Original Message-----
> From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com]
> Sent: Monday, April 11, 2005 11:12 PM
> To: AccessD at databaseadvisors.com
> Subject: [AccessD] Strange Report Page Numbering
>
>
> Dear List:
>
> I have a one page report and at the bottom it prints Page 1 of 2. I'm
> using the standard ="Page " & [Page] & " of " & [Pages] to print the
> page numbers which was actually generated by the Access report wiz.
>
> This has never failed before.
>
> Has anyone seen anything like this?
>
> MTIA
>
> Rocky Smolin
> Beach Access Software
> http://www.e-z-mrp.com
> 858-259-4334
> --
> 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
>