I have set up in the detail section some data, then I have some stuff that needs to appear in the footer, however, if the footer cannot fit on the page with the details, the page breaks and goes to a new one.

Is there a way to have the footer continue under the detail and break within the footer at any point? I tried setting Keep Together = "NO", however it will still show the detail, and since there is not enough room, move all of the footer to a new page. Is there a way to keep the footer underneath and just have it break in the footer?

Thanks for the help!

No.
The page header and page footer occupy fixed locations.

It sounds like you need to look at moving your page footer contents into a group footer instead .

Even when I put it into a group footer it still breaks it. I put the Keep together setting together to NO as well.

Is there any other way to trick it into not breaking it. This stuff needs to appear right after when the detail section ends, however I don't want it to break.

I'm afraid I'm lost. You have made what appear to me to be contradictory statements...

"Is there a way to have the footer continue under the detail and break within the footer at any point"

"keep the footer underneath and just have it break in the footer?"

"trick it into not breaking it"

" I don't want it to break."

Can you clarify what you want, please.

Oh sorry.

Ok, here is what I have so far. I have all of the data I need going into the detail section. When I first attempted, I put the data I needed at the bottom into the report footer. However, what this did, since the footer data was too big to fit on the page, was break right below where the detail data stopped, then put it on a new page.

So I took the previous suggestion and made a group in my Query called Group:1, so everything was in this group 1. I then created a group based on that group, still have all the detail data in the detail section, then moved everything from the report footer into the group footer.

Once again, this lists all of the detail data, but then breaks into a new page because the data in the group footer is being maintained together and puts it onto a new page. Same as if it was on the report footer.

At the end of the day, I want all of the detail data to produce, could be anywhere from 3 - 100 lines depending on how much information there is.

I have stuff that needs to go right at the bottom of where the detail section stops. However, I don't want this data to page break, if even 1 line or 15 lines in the footer can fit on the page, I want them to. I don't want to footer to be constrained to being kept together, I want it to appear right under the detail if it can fit or not.

So for an example, say I have data in the detail that will appear as
1
2
3
4

In the group the data will appear as:

A
B
C
D

I don't want ABCD to be put on a new page if ALL of it can't fit.

I want it to appear as

1
2
3
4
A
B
*Page Break
C
D

OR if the data can fit then

1
2
3
4
A
B
C
D

OR

1
2
3
4
A
B
C
*Page Break
D

Does that make sense? ABCD MUST appear at the bottom, but I don't want it to be broken from the detail data just cause it won't fit.

Thanks for your input.

Then it seems to me that what you need is for the Keep Together property for the Group Footer to be set to No and the Keep Group Together property for the group to be set to No.

I just tried that and it still results the same.

Well those are the 2 keep together settings that matter.
Apart from that the only reason I can think of is that you have a page throw property set which is forcing this outcome.

If you can't find it then post a sample database containing the problem.

Here is the file. You must open the master form, then run the report, Repor1, this is by no means a finished product.

I want whatever is on page 2 that can fit, to appear on page 1, if it can, there is room, I know all won't fit. The form header is also at about the distance that it needs also, so that also has to be there.

Thanks for the help!

Well Access is being very clever in a manner that is working against you.
I have never come across this feature before but it appears that the fact that you have built complete vertical lines from bits has told access that this is to be treated as a single vertical line which it won't split.
If you introduce even the smallest of gaps between the vertical bits then the section splits wherever necessary.
But obviously it will not look as it does now. You have to consider redesigning the layout so that the lines aren't touching.

Thank you so much for looking into it. I appreciate your help, I will try and adjust it to avoid the problem. I was trying to model a system that is already used in excel, so the lines were a part of that excel sheet that we would use.

I can understand your approach to this design and it is exactly what I would have done myself.