How to prevent Scroll bar from running into header and footer of continuous access form.

Posted on 2012-09-19
Last Modified: 2012-09-19
Does anyone know if this is possible? My reasons for wanting to prevent this are rather unique but in the end the problem can be solved by preventing the scroll bar from running into the header and footer for the continous form.

Thanks for the advice!
Question by:SeyerIT
    LVL 29

    Accepted Solution

    The only way I know would be to remove the controls you have in the header and footer and put them in another form.  Then insert the continuous form there as a subform.
    LVL 14

    Assisted Solution

    by:Bill Ross

    Create a subform with the detail data only - make sure it has the vertical scroll bar enabled.
    Insert the subform in the detail section of the main form replacing all the current detail.
    Remove the scroll bar from the main form.


    LVL 29

    Expert Comment

    Also on the main form, set the RecordSelectors property and NavigationButtons property to NO.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    In the article entitled Working with Objects – Part 1 (, you learned the basics of working with objects, properties, methods, and events. In Work…
    Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
    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…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    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

    12 Experts available now in Live!

    Get 1:1 Help Now