Go to report design view and shrink the spaces as needed. The space you identified in yellow is likely between the report footer and detail section. If you need more help, perhaps post an image of the report in design view instead.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Now I think your OP image is of a layout view, not a report view or print preview. Do you have this same issue in either of those views, and if so, do you have the background control set to 'Can Grow'?
Yes it does the same thing in print and report view. When I print it actually forces the data to the next page. I do have it set to can grow as when I change it to know all the data doesn't show.
Thanks
Pete
Then look at the property sheet format tab and see if you have Force New Page is 'None' or one of the other options. I suspect you have a page break set there.
So no solution then? I'm out of ideas, I'm afraid - unless you want to post a zipped copy of your db.
Here you go.. Got rid of all the data as it cannot be show. As well as some report.However the report I am having issues with is there.
Thanks
PeterTesting_Litigation.zip
I guess you did not notice my profile - I'm stuck in 2007 and can't open your file. You'd have to save as 2007 first. However, if there's no data at all, the report will be of no use. I understand if you can't include any real data and don't have the time to enter any fake data. That would be true for anyone who could open your db, I think.
I agree with Micron --little or no data will probably hide the issue.
Can you make a fake record or 2 or 3. Just garbled text or copy some text from internet or a file just to get some volume.
For names and cities type info use things like Porky Pig, General Purpose, Sheza Winner....
Big City, Centretown, LittleRock... get creative.
There is data in the db just junk data.. The issue does come up when you open the report.
I don't seem to have the option to save it as Access 2007 file...Unless I am missing someting
With no form/report etc. object selected, Office button > Save As > 2007
At least that's what I see with my version.
The only option I have is 2003 and even then it says I can't due to missing items.
God why does microsoft make things so difficult.
Sorry, sometimes works, sometimes not. As long as you have enough data to produce a report, I'm sure someone else will jump in. If not, you could try opening a new db, save as (2003 is fine) and import your report, tables and queries and whatever else is needed. It'll likely complain about some features not being compatible, but hopefully will do the import anyway.