Pages.Remove method (Access)
The Remove method removes a Page object from the Pages collection of a tab control.
Syntax
expression.Remove (Item)
expression A variable that represents a Pages object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Item | Optional | Variant | An integer that specifies the index of the Page object to be removed. The index of the Page object corresponds to the value of the PageIndex property for that Page object. If you omit this argument, the last Page object in the collection is removed. |
Remarks
The Pages collection is indexed beginning with zero. The leftmost page in the tab control has an index of 0, the page immediately to the right of the leftmost page has an index of 1, and so on.
You can remove a Page object from the Pages collection of a tab control only when the form is in Design view.
Example
The following example removes pages from a tab control.
Function RemovePage() As Boolean
Dim frm As Form
Dim tbc As TabControl, pge As Page
On Error GoTo Error_RemovePage
Set frm = Forms!Form1
Set tbc = frm!TabCtl0
tbc.Pages.Remove
RemovePage = True
Exit_RemovePage:
Exit Function
Error_RemovePage:
MsgBox Err & ": " & Err.Description
RemovePage = False
Resume Exit_RemovePage
End Function
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.