Unable to Hide Report Footer (1 Viewer)

JamesJoey

Registered User.
Local time
Today, 06:02
Joined
Dec 6, 2010
Messages
608
I have a report I put on a main form. The report footer backcolor is set to the same color as the main form detail backcolor.
Even if I set the report footer to zero it shows up as a white box. If I set the report footer to 5 inches it looks fine.
I even set the report footer to Visible-No and that didn't work.
ReportFooter.png

You can see the difference. Iv'e tried just about everthing
I'm trying to figure out why I need to set the footer height so it don show.

Any ideas?
James
 

CJ_London

Super Moderator
Staff member
Local time
Today, 10:02
Joined
Feb 19, 2013
Messages
16,553
To me it looks like your subreport control height needs adjusting to effectively hide the footer
 

theDBguy

I’m here to help
Staff member
Local time
Today, 03:02
Joined
Oct 29, 2018
Messages
21,357
When you make the footer taller? Do you end up having an extra page?
 

JamesJoey

Registered User.
Local time
Today, 06:02
Joined
Dec 6, 2010
Messages
608
That didn't work. The report is based on a query the show events a week.
I put the main form in layout view and pulled up until the white disappeared.
Then I added a record and set the date to next Thursday. The detail section
didn't expand to show the new event which I set 5 days from now.

I'm at a loss
 

theDBguy

I’m here to help
Staff member
Local time
Today, 03:02
Joined
Oct 29, 2018
Messages
21,357
Just FYI, crossposted here.

 

JamesJoey

Registered User.
Local time
Today, 06:02
Joined
Dec 6, 2010
Messages
608
That didn't work. The report is based on a query the show events a week.
I put the main form in layout view and pulled up until the white disappeared.
Then I added a record and set the date to next Thursday. The detail section
didn't expand to show the new event which I set 5 days from now.

I'm at a loss
I also set the footer's Visibly property to No.
 

JamesJoey

Registered User.
Local time
Today, 06:02
Joined
Dec 6, 2010
Messages
608
Ok. The current report I have set the report height footer to 0.
In order to eliminate the white you must put the report in design view and drag the footer to
about 5 or 8 inches.
 

Attachments

  • ReportFooterAnomoly.accdb
    608 KB · Views: 349
Last edited:

isladogs

MVP / VIP
Local time
Today, 10:02
Joined
Jan 14, 2017
Messages
18,186
Better still, don't use a report on a form. Although possible, some functionality isn't available and behaviour isn't always what you expect!
 

JamesJoey

Registered User.
Local time
Today, 06:02
Joined
Dec 6, 2010
Messages
608
It's no different on the report.
I still get the white in the footer even though I set the backcolor to blue.
In fact, if I slide open the report width the white appears.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 03:02
Joined
Oct 29, 2018
Messages
21,357
Ok. The current report I have set the report height footer to 0.
In order to eliminate the white you must put the report in design view and drag the footer to
about 5 or 8 inches.
Hi James. Thanks for posting a copy of your db. Everything makes sense now. I don't know if there is a solution to your particular problem, but I offer one potential workaround. I know it's not the best one, but maybe it can get you started in the right direction.
 

Attachments

  • ReportFooterAnomoly.zip
    59.7 KB · Views: 186

JamesJoey

Registered User.
Local time
Today, 06:02
Joined
Dec 6, 2010
Messages
608
Ah. I see the query was altered,
Seem to work ok now.
Although I don't understand the sql it worked.

Thanks much for all the assistance
 

theDBguy

I’m here to help
Staff member
Local time
Today, 03:02
Joined
Oct 29, 2018
Messages
21,357
Ah. I see the query was altered,
Seem to work ok now.
Although I don't understand the sql it worked.

Thanks much for all the assistance
You're welcome. Glad we could assist. Good luck with your project.
 

CJ_London

Super Moderator
Staff member
Local time
Today, 10:02
Joined
Feb 19, 2013
Messages
16,553
to be clear, its not the footer you are seeing as white, it is the unused part of the subreport control as I said in post #2, so the only other way is to adjust the height of the subreport control to exclude the unused space

Based on your original qryWeeklyAgenda query, copy/paste this into the load event of your frmHome form

Code:
Dim rs As DAO.Recordset

Set rs = CurrentDb.OpenRecordset("SELECT Count(Q.Dates) AS numHeaders, Sum(Q.Items) AS numItems" _
& " FROM (SELECT qryWeeklyAgenda.ReminderDate AS Dates, Count(qryWeeklyAgenda.ReminderID) AS Items" _
& " FROM qryWeeklyAgenda" _
& " GROUP BY qryWeeklyAgenda.ReminderDate)  AS Q")

If Not rs.EOF Then rptWeeklyAgenda.Height = (rs!numItems * rptWeeklyAgenda.Report.Section(0).Height) + (rs!numheaders * rptWeeklyAgenda.Report.Section(5).Height) - 50
 

JamesJoey

Registered User.
Local time
Today, 06:02
Joined
Dec 6, 2010
Messages
608
That worked.
Only thing is if I inadvertently double click the area on the subReport below the
detail it disappears except for a horizontal line.
Close the form and reopen and back to normal.
 

Users who are viewing this thread

Top Bottom