|
| 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
October 3rd, 2005, 02:55 PM
|
|||
|
|||
blank page caused by pagebreak
I have a report that is grouped by compnay name and then technician Name. The
requirement is -- each technician info per page. I added a pagebreak in the Technician group footer to meet the requirement. Because the pagebreak in the Technician group footer, the last page always blank. I added the following codes in the detail_format event to prevent user to see the last blank page: If Me.Page = Me.Pages - 1 Then GroupFooter2.Visible = False Else GroupFooter2.Visible = True End If The above code works fine so the users will not see the last blank page. However, when I print it. It print the report without pagebreak. I want to hide the last blank page from viewing and also not to print the last blank page. Is there any way to do it? -- Software Developer 
|
|
#2
October 4th, 2005, 12:21 AM
|
|||
|
|||
|
Is it just beacause of the width of your report? Maybe its just that your
report is running over the page and that is why it is having a blank page. Try just checking your widths on everything? "Ming" wrote: I have a report that is grouped by compnay name and then technician Name. The requirement is -- each technician info per page. I added a pagebreak in the Technician group footer to meet the requirement. Because the pagebreak in the Technician group footer, the last page always blank. I added the following codes in the detail_format event to prevent user to see the last blank page: If Me.Page = Me.Pages - 1 Then GroupFooter2.Visible = False Else GroupFooter2.Visible = True End If The above code works fine so the users will not see the last blank page. However, when I print it. It print the report without pagebreak. I want to hide the last blank page from viewing and also not to print the last blank page. Is there any way to do it? -- Software Developer
|
|
#3
October 4th, 2005, 01:04 AM
|
|||
|
|||
|
The last page is always blank because that is what you are telling Access to
do. Normally this is not done by adding the page break control. There are report properties that woill handle this for you. You should set the property for the group footer to "Force new page" = "After section". Hope this helps... Ming wrote: I have a report that is grouped by compnay name and then technician Name. The requirement is -- each technician info per page. I added a pagebreak in the Technician group footer to meet the requirement. Because the pagebreak in the Technician group footer, the last page always blank. I added the following codes in the detail_format event to prevent user to see the last blank page: If Me.Page = Me.Pages - 1 Then GroupFooter2.Visible = False Else GroupFooter2.Visible = True End If The above code works fine so the users will not see the last blank page. However, when I print it. It print the report without pagebreak. I want to hide the last blank page from viewing and also not to print the last blank page. Is there any way to do it? -- Boyd Hi Tech Coach http://www.hitechcoach.com Message posted via http://www.accessmonster.com
|
|
#4
October 4th, 2005, 08:35 PM
|
|||
|
|||
|
Hello Boyd,
Thank you so much for your help. I made the changes based on you suggestion and it works. Best Regards Software Developer "Boyd "Hi Tech Coach" via AccessMonster" wrote: The last page is always blank because that is what you are telling Access to do. Normally this is not done by adding the page break control. There are report properties that woill handle this for you. You should set the property for the group footer to "Force new page" = "After section". Hope this helps... Ming wrote: I have a report that is grouped by compnay name and then technician Name. The requirement is -- each technician info per page. I added a pagebreak in the Technician group footer to meet the requirement. Because the pagebreak in the Technician group footer, the last page always blank. I added the following codes in the detail_format event to prevent user to see the last blank page: If Me.Page = Me.Pages - 1 Then GroupFooter2.Visible = False Else GroupFooter2.Visible = True End If The above code works fine so the users will not see the last blank page. However, when I print it. It print the report without pagebreak. I want to hide the last blank page from viewing and also not to print the last blank page. Is there any way to do it? -- Boyd Hi Tech Coach http://www.hitechcoach.com Message posted via http://www.accessmonster.com
|
|
#5
October 4th, 2005, 08:37 PM
|
|||
|
|||
|
Hello,
Thank you for your responding. I made the changes based on Boyd's suggestion. It works as required now. -- Software Developer "leabee1" wrote: Is it just beacause of the width of your report? Maybe its just that your report is running over the page and that is why it is having a blank page. Try just checking your widths on everything? "Ming" wrote: I have a report that is grouped by compnay name and then technician Name. The requirement is -- each technician info per page. I added a pagebreak in the Technician group footer to meet the requirement. Because the pagebreak in the Technician group footer, the last page always blank. I added the following codes in the detail_format event to prevent user to see the last blank page: If Me.Page = Me.Pages - 1 Then GroupFooter2.Visible = False Else GroupFooter2.Visible = True End If The above code works fine so the users will not see the last blank page. However, when I print it. It print the report without pagebreak. I want to hide the last blank page from viewing and also not to print the last blank page. Is there any way to do it? -- Software Developer
|
|
#6
October 5th, 2005, 02:39 PM
|
|||
|
|||
|
Hello Boyd,
I am doing testing now and noticed that if I set "Force new page" - "After section", it will print one entry per page all right. However, the requirement is one technicain per page. Under tech group, it lists tasks base on the Tech name. Sometimes one tech can have multiple tasks. -- Software Developer "Boyd "Hi Tech Coach" via AccessMonster" wrote: The last page is always blank because that is what you are telling Access to do. Normally this is not done by adding the page break control. There are report properties that woill handle this for you. You should set the property for the group footer to "Force new page" = "After section". Hope this helps... Ming wrote: I have a report that is grouped by compnay name and then technician Name. The requirement is -- each technician info per page. I added a pagebreak in the Technician group footer to meet the requirement. Because the pagebreak in the Technician group footer, the last page always blank. I added the following codes in the detail_format event to prevent user to see the last blank page: If Me.Page = Me.Pages - 1 Then GroupFooter2.Visible = False Else GroupFooter2.Visible = True End If The above code works fine so the users will not see the last blank page. However, when I print it. It print the report without pagebreak. I want to hide the last blank page from viewing and also not to print the last blank page. Is there any way to do it? -- Boyd Hi Tech Coach http://www.hitechcoach.com Message posted via http://www.accessmonster.com
|
|
#7
October 5th, 2005, 04:52 PM
|
|||
|
|||
|
Hello Boyd,
You can ignore my last message. I found a way to do it. Thanks -- Software Developer "Boyd "Hi Tech Coach" via AccessMonster" wrote: The last page is always blank because that is what you are telling Access to do. Normally this is not done by adding the page break control. There are report properties that woill handle this for you. You should set the property for the group footer to "Force new page" = "After section". Hope this helps... Ming wrote: I have a report that is grouped by compnay name and then technician Name. The requirement is -- each technician info per page. I added a pagebreak in the Technician group footer to meet the requirement. Because the pagebreak in the Technician group footer, the last page always blank. I added the following codes in the detail_format event to prevent user to see the last blank page: If Me.Page = Me.Pages - 1 Then GroupFooter2.Visible = False Else GroupFooter2.Visible = True End If The above code works fine so the users will not see the last blank page. However, when I print it. It print the report without pagebreak. I want to hide the last blank page from viewing and also not to print the last blank page. Is there any way to do it? -- Boyd Hi Tech Coach http://www.hitechcoach.com Message posted via http://www.accessmonster.com
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Header & Footer not on first page but on subsequent pages | KM1 | General Discussion | 14 | June 13th, 2005 12:36 AM |
| "Blank page" is not blank. It contains text written weeks ago. | Kingfish | General Discussion | 3 | January 7th, 2005 09:52 PM |
| Creating an "unmovable" blank page | Dan | Page Layout | 1 | October 11th, 2004 11:12 PM |
| NUMBERING the pages | Bob | New Users | 7 | June 14th, 2004 12:20 AM |
| Adding text to blank pages | Dave | Page Layout | 1 | June 9th, 2004 06:54 AM |
Linear Mode
