Unable to Hide Report Footer (1 Viewer)

JamesJoey

Registered User.
Local time
Today, 12:43
Joined
Dec 6, 2010
Messages
602
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, 17:43
Joined
Feb 19, 2013
Messages
13,386
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, 09:43
Joined
Oct 29, 2018
Messages
16,614
When you make the footer taller? Do you end up having an extra page?
 

JamesJoey

Registered User.
Local time
Today, 12:43
Joined
Dec 6, 2010
Messages
602
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, 09:43
Joined
Oct 29, 2018
Messages
16,614
Just FYI, crossposted here.

 

JamesJoey

Registered User.
Local time
Today, 12:43
Joined
Dec 6, 2010
Messages
602
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, 12:43
Joined
Dec 6, 2010
Messages
602
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: 89
Last edited:

isladogs

CID VIP
Local time
Today, 17:43
Joined
Jan 14, 2017
Messages
15,418
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, 12:43
Joined
Dec 6, 2010
Messages
602
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, 09:43
Joined
Oct 29, 2018
Messages
16,614
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: 24

JamesJoey

Registered User.
Local time
Today, 12:43
Joined
Dec 6, 2010
Messages
602
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, 09:43
Joined
Oct 29, 2018
Messages
16,614
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, 17:43
Joined
Feb 19, 2013
Messages
13,386
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, 12:43
Joined
Dec 6, 2010
Messages
602
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