Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Jan 2003
    Location
    Central Florida, USA
    Posts
    505
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Changing A Form Tab Control (Access 97)

    Is there a way to change the properties of a tab control once it has been placed on a form? I inherited a form that looks nice, uses a tab control, but now looks crowded and requires a horizontal scroll bar to see all the tabs. I am aware that you can set a tab control to multiple rows BEFORE you place it on the form, but cannot for the life of me find it in the properties of the tab control that already exists. Am I crazy?

    Thanks!

    Kwvh

  2. #2
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Changing A Form Tab Control (Access 97)

    You can use the Tab Control's MultiRow property. This property can be set at runtime as well as in design mode. Example of sub that toggles property on & off when button clicked:

    Private Sub TabButton_Click()

    Me.TABCTL1.MultiRow = Not Me.TABCTL1.MultiRow

    End Sub

    Small sample db (A97 format) attached that illustrates this, form has Tab Control with 6 tabs (Pages), the button toggles them from 2 rows to single row or from single row to 2 rows.

    HTH
    Attached Files Attached Files

  3. #3
    4 Star Lounger
    Join Date
    Jan 2003
    Location
    Central Florida, USA
    Posts
    505
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: Changing A Form Tab Control (Access 97)

    Mark,

    Thanks again for your solution. It works great! That is a super control you have that allows switching of the fly. I never considered that. Tunnel vision I suppose.

    Ken

Posting Permissions

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