Excel- How to hide frame and additional line in subform


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
Who is Participating?
@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.
Sorry, but your question is not so clear.  Can you upload what you have?
Jeffrey CoachmanMIS LiasonCommented:
...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, ...post 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.
motioneyeAuthor Commented:
Hi als315,
Right to my problems, thanks for ur gudei :)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.