To use a command button to display a page, add an event procedure to the button's OnClick event that sets the tab control's Value property to the integer that identifies the appropriate page.īy using the Value property with the Pages collection, you can set properties at run time for the page that is on top. This is useful if you set a tab control's Style property to None (which displays no tabs) and want to use command buttons on the form to determine which page has the focus. For example, the following statement moves the focus to the third page of TabControl1: TabControl1 = 2 Setting a tab control's Value property at run time changes the focus to the specified page, making it the current page. For example, the following statement returns the value for the current page of TabControl1: TabControl1.Valueīecause the Value property is the default property for a tab control, you don't have to refer to it explicitly. By reading the Value property at run time, you can determine which page is currently on top.
#ONCLICK TO A NEW TAB BUT DONT GO TO IT CODE#
The Value property is available only in VBA code or in expressions. For example, to determine the number of pages in TabControl1, use the following statement: Ī tab control's default property is Value, which returns an integer that identifies the current page: 0 for the first page, 1 for the second page, and so on. Note that this property is not a property of the tab control itself, but of its Pages collection, so you must explicitly refer to the collection.
The Pages collection has one property, Count, that returns the number of pages in a tab control. In this case, if you want to maintain an absolute reference to a page, refer to the page's Name property. If a user or code changes a page's PageIndex property, the reference to the page's index and the page's position in the page order change. For example, to change the value of the Caption property of a page with its Name property set to, use the following statement.
There is no default collection for the TabControl object, so when referring to items in the Pages collection by their index value, or to properties of the Pages collection, you must explicitly refer to the Pages collection.įor example, to change the value of the Caption property for the first page of a tab control named TabControl1 by referring to its index value in the Pages collection, you can use the following statement: TabControl1.Pages(0).Caption = "First Page"īecause each page is a member of the form's Controls collection, you can refer to a page solely by its Name property without referring to the tab control's name or its Pages collection.
Each page in the Pages collection can be referred to by either its PageIndex property setting (which reflects the page's position in the collection starting with 0), or by the page's Name property setting. Each page in a tab control is referenced as a member of the tab control's Pages collection. That is, you can omit the reference to the Controls collection from the expression, like this: Form1!TabControl1Ī tab control contains one or more pages. However, because the Controls collection is the default collection of the Form object, you don't have to explicitly refer to the Controls collection. For example, to refer to a tab control named TabControl1 on a form named Form1, you can use the following expression: Form1.Controls!TabControl1 In most ways, a tab control works like other controls on a form and can be referred to as a member of a form's Controls collection. A tab control is useful when your form contains information that can be sorted into two or more categories. Use a tab control to present several pages of information about a single form.
0 kommentar(er)
