Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by dlightful
-
Reporting - Change SubReport background color using VBA rpt open event
Yes, I agree, that would work, but let me make it a little harder... [Subreport1] does not reside as a "Reports" object. I merely created my main report by dragging and dropping several subForms from their home as "Forms" objects. The entire report works as I intend it to, but I want to...- dlightful
- Post #3
- Forum: Microsoft: Access Other topics
-
Reporting - Change SubReport background color using VBA rpt open event
I want to change the background color using VBA on the fly to a subReport. I've specified the following in the main report 'Event Open procedure' but it won't work. Private Sub Report_Open(Cancel As Integer) me!subreport1.Report!Section(0).BackColor = vbBlue End Sub- dlightful
- Thread
- Replies: 3
- Forum: Microsoft: Access Other topics
