Excel- How to hide frame and additional line in subform

Posted on 2012-08-11
Last Modified: 2012-08-12

How do I with my subform in access below to hide frame and additional line ? This form always have one line of record and additional line/ row are not necessary
Question by:motioneye
    LVL 29

    Expert Comment

    Sorry, but your question is not so clear.  Can you upload what you have?
    LVL 74

    Expert Comment

    by:Jeffrey Coachman
    ...and do this too:

    Sample database notes:
    1. Back up your database(s).
    2. Combine the front and back ends into one database file.
    3. Remove any startup options, unless they are relevant to the issue.
    4. Remove any records unless they are relevant to the issue.
    5. Delete any objects that do not relate directly to the issue.
    6. Remove any references to any "linked" files (files outside of the database, Images, OLE Files, ...etc)
    7. Remove any references to any third party Active-x Controls (unless they are relevant to the issue)
    8. Remove, obfuscate, encrypt, or otherwise disguise, any sensitive data.
    9. Unhide and hidden database objects
    10. Compile the code. (From the VBA code window, click: Debug-->Compile)
    11. Run the compact/Repair utility.
    12. Remove any Passwords and/or security.
    13. If a form is involved in the issue, set the Modal and Popup properties to: No
        (Again, unless these properties are associated with the issue)
    14. Post the explicit steps to replicate the issue.
    15. Test the database before posting.

    In other words, a database that we can easily open and immediately see and/or troubleshoot the issue.
    And if applicable, also include a clear graphical representation of the *Exact* results you are expecting, based on the sample data.
    LVL 39

    Accepted Solution

    @motioneye: if you like to have subform without frame, select border around inserted subform and set Border Style to transparent:
    borderAdditional line you can remove if you disallow additions in subform (Data tab):
    lineYou can also change default view of subform to Single form, in this case you will see only one record.

    Author Comment

    Hi als315,
    Right to my problems, thanks for ur gudei :)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    In the article entitled Working with Objects – Part 1 (, you learned the basics of working with objects, properties, methods, and events. In Work…
    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

    760 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

    7 Experts available now in Live!

    Get 1:1 Help Now