Referencing Subreports

K

Ken

Hi,

My main report changes background color every three records.

I have a sub-report I would like to set the background color to match the
background color of my report.

I would also like to make the footer section only as big as the subreport.


Here is the code I have tried so far with no results:

Cancel = IsNull(Me.[RefitUnitID]) - do not show if no records exist

Me.RefitFooter.BackColor = Me.Section(acDetail).BackColor - did not work

Me.Refits_SubReport.Form.Top = 0 - did not work

Me.RefitFooter.Height = Me.Refits_SubReport.Form.WindowHeight - read only

Me.Section("RefitFooter").BackColor = Me.Section(acDetail).BackColor - did
not work

Any help would be appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display line when... 4
Format Question 1
Main Report without Data 1
Report Formating Code Question 3
Conditional formatting of detail section in an access form 4
How to address subreports properties from main report 1
Colouring alternate detail lines code doesn't work 1
Please help! 1

Top