Report formatting

Posted on 2011-10-03
Last Modified: 2012-05-12
I've added a subform to a report in the details pane and it's displaying the scrollbars and alternating grey and white on each line.  How do I remove this? The subform is a continious form. See attached img.
Question by:gcgcit
    LVL 47

    Expert Comment

    by:Dale Fye (Access MVP)
    I've never actually added a subform to a report.  I generally convert it to a report, then added it as a sub-report.  Since reports don't have record selectors and nav panes you don't have to worry about those.
    LVL 47

    Accepted Solution

    if you insist on putting the form inside the report, you could probably use the Report_Load event to modify the RecordSelectors and NavigationButtons properties, something like:

    Private Sub Report_Load

        me.sub_Form.form.recordselectors = false
        me.sub_Form.form.Navigationbuttons = false

    End sub

    Author Comment

    That worked for the navigation thanks - how do I get the grey of every other line removed?
    LVL 47

    Assisted Solution

    by:Dale Fye (Access MVP)

    me.sub_form.form.section(acDetail).alternatebackcolor = me.sub_form.form.section(acDetail).backcolor


    Author Comment

    That worked. Thanks. I have another formating question but I'll pose a new question to make it fair for point allocation.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    This article is a continuation or rather an extension from Cascading Combos ( and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now