Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2008

    Unanswered: Scroll Bar, Form Height, FREEZE control

    When I open my Access form, the scroll bar thumb is positioned about 30% across the scroll bar. I want it to be positioned to the far left of the bar when the form opens. I have tried looking through the properties, but maybe this is something that has to be coded in an event procedure when the form opens or loads. How can this be done?

    Is there a way to "freeze" colums on an Access form like in Excel where the "frozen" columns stay in the form regardless of how far the user scrolls to the right?

    Also, while I'm here, I may aswell ask what the coding would be to set the height of the form when it opens/loads. I didn't see a height property in the properties list for the form.

  2. #2
    Join Date
    Jan 2007
    Provided Answers: 12
    Try setting focus to a control to the left on your form on load?
    Home | Blog

  3. #3
    Join Date
    Nov 2007
    Adelaide, South Australia
    Beats me, no form of mine is ever wider than the screen
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  4. #4
    Join Date
    Dec 2004
    Madison, WI
    You can utilize code to resize a form depending on the screen size set for windows (examples of this code are in the code bank) or design the form in a way so you don't have to even utilize the scroll bar (I hate having forms with scroll bars and making the user utilize a scroll bar.) Tab controls also work very well for arranging data fields within tabs that would normally cause the need for a scroll bar. If you must utilize a scroll bar, go with georgev's suggestion on setting the focus to a field on the far left. If you are using a datasheet view verses a single form/continuous view, consider adjusting the column widths and basing it off a query or making it a continuous form where you set up the fields widths and have more control.
    Last edited by pkstormy; 07-15-08 at 23:30.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts