Help with Tab control

[moishy]

Hello all Experts,

Is it possible to disable automatic Tab resize on double clicking?

 

[missinglinq]

I'm not aware of any such native behavior using a Tabbed Control. Perhaps you could explain a little more clearly.

Also, what version of Access are you running.

If you're running 2007/2010, you're not actually speaking of Tabbed Documents/Forms (as opposed to Overlapping Windows) are you? Your title says Tabbed Control.

Linq ;0)>

 

[vbaInet]

If you're running 2007/2010, you're not actually speaking of Tabbed Documents/Forms (as opposed to Overlapping Windows) are you? Your title says Tabbed Control.

Linq ;0)>

I'm suspecting that too.

 

[missinglinq]

The only thing I can think of, with a true Tabbed Control, is that it's not actually 'resizing,' but rather it is too long for the Form, and when changing pages the Focus is on a Control low on the Page, forcing the Page to 'rise' and appearing to make it suddenly larger. We certainly get enough reports of this both here and on other forums.

Linq ;0)>

 

[moishy]

Sorry for the late response, the issue I was having was no issue at all only a silly mistake of mine.
I had set the Auto Resize property of the form to No and re-sized the form by a click on each page setting the Inside Height and Width. I thought that the click event was only for the 'tab' not realizing that it applies the whole page.
btw I was using Access 2003.

 

[missinglinq]

Well isn't that embarrassing?

Actually, we only see this mistake about a dozen times a week! The event you need, in order to fire code when clicking on a "tab" is the OnChange event for the Tabbed Control! Here's a boilerplate response I usually post when it does:

The first thing to understand is that tabbed pages are indexed starting with zero, i.e. the first page has a value of 0, second page has a value of 1, third page has a value of 2, etc.

Secondly, you need to understand that the OnClick event of a Tabbed Page only fires when you click on the page itself, not the tab at the top of the page!

Lastly, you need to understand that the Tabbed Control Change Event fires anytime the Tabbed Pages Change. But to base something on the change event, you have to identify the particular page that has focus.

Private Sub YourTabbedControl_Change()
  Select Case YourTabbedControl 
    Case 0  ‘First Page
      ‘Code for Page 1
    Case 1  ‘Second page
      ‘Code for Page 2
   Case 2   ‘Third page
     ‘Code for Page 3
  End Select
End Sub

Linq ;0)>