Edit

Pages.Remove method (Access)

  • Article

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.