Results 1 to 8 of 8
  1. #1
    Join Date
    Feb 2009
    Posts
    18

    Unhappy Unanswered: Can a dialog box have scroll bars?

    Hi all,

    I am working with a database that has a front end in access 2003 and a backend in SQL Server.

    My question is, can a dialog box have scroll bars? I have a form that is opened up via the OpenForm command with the acDialog parameter. The box gets a little big so vertical scroll bars are necessary; however, they do not show up when the form displays.

    The reason why I am using this form as a Dialog box is because I would like the code to halt in the main form and I would like to be able to pass values back to the calling form as described in this website here: Dialogs and prmopts in ms-access

    Is it possible to get the vertical scroll bars to appear? Or, am I totally off base in doing this?

    Please help...

    g-coding

  2. #2
    Join Date
    Feb 2009
    Posts
    18
    I think I may have some sort of solution although I'm not completely sure why it works.

    I placed a couple of page breaks on the form. Now the vertical scroll bars work!

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    My question is, can a dialog box have scroll bars?
    Ones YOU design, yes. Just set the Scroll Bars property for the form to Vertical or Both.
    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
    Feb 2009
    Posts
    18
    Unfortunately, that was part of the predicament -I had already set the scroll bar properties to verical or both on my form; yet, it still did not display the scroll bars. I have no idea why.

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Does the form have enough information on it to REQUIRE a vertical scroll bar? If the form isn't deep enough, I don't think the VSB will display regardless of the setting?
    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

  6. #6
    Join Date
    Feb 2009
    Posts
    18
    What kind of information are you thinking of?

    The form I have has a lot of information including a bunch of textboxes, a couple dropdowns, etc. on it. I don't know if that's what you mean though.

  7. #7
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Does the form NEED a scrollbar or is everything on the form visible without the need to scroll?
    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

  8. #8
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    If your records in the "list-type" format for a "continuous" form exceeds the length of the form (ie. they no longer all fit on the form), you'll then see the vertical scroll bar, otherwise you won't see the vertical scroll bar. Try adding more records until you exceed the length of the form. There are some other circumstances.
    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
  •