Is there a TREE listing object/funtion 1

[TruthAndBeauty]

I know Access has switchboards and tabs, but is there a tree (expandable/collapsible) I can provide the user to navigate around the application. I've searched on "Tree" in Help and Tek-tips but nothing come up.

Thanks

 

[psemianonymous]

You can use Microsoft's TreeView control (OCX) - the control isn't built into Access, but you can use it via an external reference.

From form design,
Insert->ActiveX Control

 

[RickSpr]

Note that you can not distribute the TreeView control unless you have a license to do so. Office Developer Edition includes the license, and I think Visual Studio and VB do also, but I believe the Office Developer license is required in order to distribute it as part of an Access application.

Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein

 

[TruthAndBeauty]

I found the MS Tree View (6.0) in the insert ActiveX control. I inserted it on a new form. There are no instruction and the property screens don't give me a clue how to implement it. My 3" thick MSAccess book don't address how to use OCX. Hmmmm.

I'm heading out to microsoft.com and try to find some information.

I didn't know about the license and I'll check it out.

I appreciate you folks helping out.

 

[TruthAndBeauty]

Does anyone know the structure an/or properties of the tree levels (branches)?

I've got the tree working (data/expand/collapse) with 3 levels (parent/child/grandchild) ad now I'm trying to work with the selections. I can see the vaue of the selected item (mytree.selectedItem).

There is a mytreeView.top, MyTreeView.height, MyTreeView.width, MyTreeView.Name

I've found some code indicating there is a MytreeView.key which takes on the value of the first 5 characters of the selected value.

I need to react to a selection made only at the grandchid level; however, I haven't found an easy way to detect that the selection is at the grandchild.

I'd like to place folder icons and report icons onthe tree if possible.

Any help is appreciated.

Robert

 

[ProjectExplorer]

Go to the MSDN library and search for treeview - there are plenty of examples. To add icons you also need to place the MS ImageList component on your form and reference it in the Treeview properties.