Results 1 to 9 of 9
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Form question (2000)

    I have a form that has a right scroll bar. When I open the form, the right scroll bar is down a little so that you have to push it up to see the top of the form. I have tried all the properties to try to correct this. Is there something I am missing so that the form opens so the top of the form isn't hidden? Thanks for any help.

  2. #2
    New Lounger
    Join Date
    Mar 2004
    Location
    Gloucestershire, England
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Form question (2000)

    This happens to me lots - even when you size it correctly in normal view and save it, it returns to being small. The following have sorted it for me:
    1) Go to the design view of the form.
    2) Drag out the sides of the form to make them larger (in this case taller)
    3) Click on the SAVE button on the tool bar.
    4) Shut the form down.
    5) Reopen it again - it's normally fine then.

    If that doesn't work - see if the Auto Resize property of the form is set to Yes. If it is, try No. This last one has applied to me when I am using sub-forms in a way I'm sure I shouldn't!

    Hope that helps

    Tony

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Form question (2000)

    Thanks Tony but no luck. The form still opens with the scroll bar part way down, hiding the top of the form.

  4. #4
    New Lounger
    Join Date
    Mar 2004
    Location
    Gloucestershire, England
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Form question (2000)

    Are the field(s)/label(s) that you cannot see in the Header or in the Detail? If there are field(s) that are not shown, does it make a difference if you change the tab order so that the one at the top is first? (or is it already?)

  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Form question (2000)

    The form has a option group control on it with option buttons in side the option group control. It just has a detail section. The top of the form has two command buttons etc. When the form opens the right scroll bar is part way down, hiding the command buttons and the top of the option group control.

  6. #6
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Form question (2000)

    Two things to look for:

    1- In the forms properties, see if the ScrollTop property is set to something other than 0.

    2- See if the form has an initilize event routine that is setting the ScrollTop of the form to something other than 0.
    Legare Coleman

  7. #7
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Form question (2000)

    I can't find the property ScrollTop in the forms properties. The form has an on activate event that has DoCmd.Restore.

  8. #8
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Form question (2000)

    Sorry, I thought I was in the Excel forum and this was an Excel userform question. I don't know how this works on an Access form.
    Legare Coleman

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Form question (2000)

    I would set the AutoResize property of the form to Yes. If that doesn't help, try the following:
    - Open the form in form view.
    - Select Window | Size to Fit Form.
    - Select File | Save.

Posting Permissions

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