Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/172286

From BetaArchive Wiki
Knowledge Base

ADT/ODE: How to Remove All Nodes from TreeView Control

Article ID: 172286

Article Last Modified on 1/20/2007


  • Microsoft Access 95 Standard Edition
  • Microsoft Access 97 Standard Edition
  • Microsoft Office 97 Developer Edition
  • Microsoft Access Developer's Toolkit 1.1

This article was previously published under Q172286

Advanced: Requires expert coding, interoperability, and multiuser skills.


The Microsoft TreeView control version 5.0 ships with Microsoft Office 97 Developer Edition.

Use the Clear method to remove all nodes in a TreeView control.

This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft Access applications using the programming tools provided with Microsoft Access. For more information about Visual Basic for Applications, please refer to the "Building Applications with Microsoft Access 97" manual.


The following example demonstrates creating a TreeView control, adding nodes, and then removing the nodes:

  1. Start Microsoft Access and open a new, blank database.
  2. Open a new form in Design view.
  3. On the Insert menu, click ActiveX Control (or click Custom Control if you are using Microsoft Access 7.0).
  4. In the Insert ActiveX Control dialog box, select the Microsoft TreeView Control, and then click OK.
  5. Set the following properties of the TreeView Control:

            TreeView Control
            Name: tvcExample
            Width: 2
            Height: 2
  6. Add a command button to the form, and set the following properties:

            Command Button
            Name: btnFillTreeView
            Caption: Fill TreeView
            Width: 1"
            Height: .25"
  7. Set the OnClick property of the command button to the following event procedure:

           Private Sub btnFillTreeView_Click()
              Dim nodX As Node    ' Declare Node variable.
              With Me!tvcExample
                ' Set Treeview control properties.
                .LineStyle = tvwRootLines  ' Linestyle 1
                ' Add Node objects
                ' First node with 'Root1' as text.
                Set nodX = .Nodes.Add(, , "r1", "Root1")
                ' Second node on root with 'Root2' as text
                Set nodX = .Nodes.Add(, , "r2", "Root2")
                ' This next node is a child of Node 1 ("Root").
                Set nodX = .Nodes.Add("r1", tvwChild, "child1", "Child")
              End With
           End Sub
  8. Add another command button to the form and set the following properties:

            Command Button
            Name: btnDeleteAllNodes
            Caption: Clear TreeView
            Width: .25"
            Height: 1"
  9. Set the OnClick property of the command button to the following event procedure:

            Private Sub btnDeleteAllNodes_Click()
            End Sub
  10. Switch to Form view and click Fill TreeView; then click Clear Treeview, and note that all nodes are removed.


For more information about nodes in the TreeView control, search the Help Index for "node object."

Additional query words: basic delete

Keywords: kbhowto kbprogramming KB172286