Results 1 to 9 of 9
  1. #1
    2 Star Lounger
    Join Date
    Aug 2002
    Location
    New Jersey, USA
    Posts
    180
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Tab Control Forms (97 sr2)

    I made a form with 6 tabs. On some of the tabs I have subforms, some just fields. My problem is the tabs hide up under the form header. The horizonal scroll bar is down just enough that you can't see the tabs and you manually have to push it back up. This is just a pain. I have tried setting the focus on the uppermost field and it still does not always work. Is there a trick I am not aware of?
    Thanks

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Tab Control Forms (97 sr2)

    having a hard time visualizing this. I suppose you've tried moving the entire tabbed control down from the form header?

    I noticed on a tabbed control I am using that it refused to re-size and was wasting screen resources and making the whole form 'jump' when setting focus to the tab control. My tabbed control holds sub-forms and the only way to get the darn thing to resize was to open each sub-form and 'resize' it's display (if you play with the window around a form in design view, it keeps that window size in display. Anyway, once I re-sized each subform the tabbed control allowed me to resize it.

    A quick way to check if this might be the problem is to open the subforms on their own and see if they are opening in a larger than needed window. then re-size their window display and re-open. Do this for all the subforms, then open the form with the tab control and try resizing it.

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Tab Control Forms (97 sr2)

    When that happens it's because you have subforms or other controls on your tab pages that don't fit within the area you think you've allocated to the tab control. When the focus moves to one of those subforms or controls, the tab control shifts up and under the form header. You're going to have to do a lot of fiddling with the various objects involved because there isn't an easy way to avoid it. The vertical scrollbar is a giveaway that the detail section of the form can't contain the entire vertical height of the tab control object within the form window.
    Charlotte

  4. #4
    Star Lounger
    Join Date
    Jan 2003
    Location
    London, England
    Posts
    59
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Tab Control Forms (97 sr2)

    charlotte:

    now I'm having the same problem--when I tab around to all the fields, the tab controls eventually show up but otherwise are not visible. What do I adjust to sort this out? I've tried making the detail bigger, the footer bigger, but it doesn't make a difference. Are there certain properties that make tab controls work better? So far, it seems like a half-baked feature. All suggestions welcome.

    Thanks.

    S.O.

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

    Re: Tab Control Forms (97 sr2)

    I use tab controls in a lot of my database applications (Access 97 SR2) and I have never experienced problems with them that hadn't been caused by myself.
    Do you see an enabled vertical scroll bar when you open the form? If so, the section that contains the tab control is too big to display everything at once.

    If you like, you could post your database for Loungers to inspect. Make a copy of your database, remove all other forms, reports etc. and just leave those tables and perhaps queries necessary for the form; the tables need only contain one or two dummy records (don't leave any sensitive information!). Compact the database, and then zip it. The zip file should be under 100 KB in size.

  6. #6
    Star Lounger
    Join Date
    Jan 2003
    Location
    London, England
    Posts
    59
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Tab Control Forms (97 sr2)

    Hi Hans:

    Thanks for the reply. I'll have to follow this up tom'w--it's the end of the work day in the UK now. :-)

    I don't have scrollbars enabled in my form--enabling them doesn't make the tab controls appear either. I'm using a thin border, no navigators (I'm trying to keep if very clean looking), autoresize/yes, popup/yes, modal/no, autocenter/yes, no minmax buttons, close/yes--I can't figure out what I did because the tab controls never appeared in form view. I thought it was because I hadn't added controls to Page 2 yet but when I did, it didn't change. Header and footer are about 0.5cm each, detail about 7cm. All of the controls fit nicely in design view.

    I'm sure it's something I haven't done--yet--as opposed to something I did. No need for MS to be so mysterious about this, IMHO.

    I may post the database tom'w. Thanks again.

    S.O.

  7. #7
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Tab Control Forms (97 sr2)

    It sounds like your form isn't allowing enough room for the tab control. Are there subforms involved? Things like form headers and footers, navigation buttons, etc., affect the available space in the detail section of the form, which is where I assume you're putting the tab control. Also, if the individual controls are on the parent form rather than actually bound to a tab control page, they may be located outside the boundaries of the tab control. When I've seen problems with tab controls, it's always been because the form in form view didn't leave enough room for the entire tab control to display without scrolling. If you didn't enable any scrollbars, you'll only be able to see those parts when you tab into the controls that occupy them, which will eventually shift the tab control down. It's still a size issue.
    Charlotte

  8. #8
    Star Lounger
    Join Date
    Jan 2003
    Location
    London, England
    Posts
    59
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Tab Control Forms (97 sr2)

    charlotte:

    thanks for the clue. so to solve this, I just added up the height in my detail, header, footer and tab controls then clicked on detail (for properties) and used the sum total of heights for my detail height. Problem solved. Form looks a little funny (w/ extra space at the bottom of the detail portion) but at least it's visible.

    thanks for leading the way again!

    S.O.

  9. #9
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Tab Control Forms (97 sr2)

    You should be able to remove some of the space in the detail section. Just make sure that when the form loads, there is enough room for the entire form on the screen and adequate room in the detail for tab control when the form actually loads, not just in design view. You'll have to tweak the size of the sections by trial and error until you get something that looks decent and works. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Charlotte

Posting Permissions

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