Need to eliminate the extra blank page on Access Report

[QingOu]

HI

My report is a bit complicated to explain. My report is for patient coming in for their appointment.

All my data are in the "Detail" section. I use multiple page breaks.
Report Default is 3 page: Reminder Letter, Information Sheet, Map

If the patient is diabetic then an extra sheet with the diabetic information will come after the second page then the map.

Everything works great but a blank page will always print after the diabetic information sheet. I try what people suggested online but it didn't work. I can get rid of the blank page manually by doing the following:

1. Go to File | Page Setup. (In Access 2007, click the Page Setup button in the Print Preview ribbon.)
2. Click on the Column tab.
3. Under Column size, click in Width text box and enter 8, then click OK.

but i don't prefer that.

please help~

 

[neednottoknow]

I dont know whether i understand you question or not.
But, have you tried Can Grow and Can Shrink?

 

[QingOu]

Yeah I did. It didn't seem to work.

 

[unclefink]

I had this problem when i first started testing and printing my reports. This is a very tedius process to fix.

Go to the report that prints before the blank sheet and view it in print preview. Check for any right indent fields extending beyond the page break.

In my situation, the "blank" page was being printed because the "single page" report prior to it had an anomoly of some sort, IE: cell lines extending mm beyond the page layout. After you shorten any fields and make all fields within the appropriate one page layout, your blank page anomoly should be no more.

Hopefully this makes sence, if not, feel free to respond back or email me at dpcmb@msn.com and i can walk you through it some more.

Good luck.

David

 

[AccessMSSQL]

I would definitely check report width and the height of your diabetic page - as unclefink suggested. If that doesn't work, I had a similar issue with a multi-section report, except I did not use page breaks. Each page of my report is in it's own grouping. You can create a report group and set the group name to an expression. In my case I just put "=1" for my first group, "=2" for my second group,etc. Put each report page in it's own group header. Set each group header's "Force New Page" property = Before Section. Then, in your code that evaluates whether to print diabetic page or not, just show or hide group holding the diabetic page. Hope this makes sense.