Results 1 to 7 of 7
  1. #1
    Join Date
    Apr 2007
    Posts
    81

    Unanswered: can I extend the Detail form more than 22"

    Hi

    I used Access 2007

    can I extend the Detail form more than 22"
    I need for form multiple choice answers and I need more than 50 question.

    thanks

  2. #2
    Join Date
    May 2008
    Location
    Raleigh, NC
    Posts
    151
    I'm not sure if there is a limitation to how long the form may be, but it would seem to be a inconvenient way to navigate something that long on a screen. Have you thought about using pages on a form or maybe a tab container and place the various questions on multiple tabs. I think that would make it much easier to navigate instead of scrolling down and down and down.....
    --If its free, take it for what its worth!

  3. #3
    Join Date
    Apr 2007
    Posts
    81
    Hi stuschmied
    thank you so much

    where I get forms samples for multiple choice answers.

    thanks

  4. #4
    Join Date
    May 2008
    Location
    Raleigh, NC
    Posts
    151

    I don't know but

    you can play around with your form and place a tab control in the center of it and place various option boxes on the tabs relating to a specific question. Use vba code to determine the various answers. I would put the code in the on_click event of a 'Submit' button.

    Hope this helps.
    --If its free, take it for what its worth!

  5. #5
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Tabbed pages is the user-friendly way to go with this problem, and NO, you cannot have a form longer than 22 inches.
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  6. #6
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Personally, I'd be using a dialog box to ask each question.

    I have a rule of thumb that says if you need a detail section deeper than a screen, you're doing something wrong.
    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

  7. #7
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Quote Originally Posted by StarTrekker
    I have a rule of thumb that says if you need a detail section deeper than a screen, you're doing something wrong.
    I agree 100% ! Making users scroll down a form is horrible design and as user-unfriendly as it comes!
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

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