Creating a nested, expanable and collapsable input design within MS Access. Like what exists in MS Project

Posted on 2011-10-11
Medium Priority
Last Modified: 2012-06-27


I am wondering if it is possible to build an input form in MS Access that will mimic the behavior and functionality that exists in MS Project. I am referring to the way you can have nested tasks that can expand and collapse with the little plus sign and minus sign. Not asking you to explain exactly how to do it as a response to this question, I am wanting to know if it is possible and hoping you can point me to some examples on the web.

Thank you!
Question by:RiverWalk
  • 2
  • 2
LVL 49

Assisted Solution

by:Dale Fye
Dale Fye earned 1000 total points
ID: 36950401
Yes, you should look into the treeview and listview controls.

Check out this explaination: http://mytreeviewblog.blogspot.com/

The author walks through about a 7 step process to explain treeviews.
LVL 75

Accepted Solution

DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 1000 total points
ID: 36950411

Sounds like an application for a treeview control.

Freeware Instant Treeview (Scroll down to bottom  of the page until you get to Access Tools)
Comes with db that has jump start (Access db) example and an online tutorial. It's very cool.

LVL 75
ID: 36950426
Additional TreeView control resources:

How to fill a Treeview control recursively in Access 2000

Here are step by step Treeview instruction with source code and references


Author Closing Comment

ID: 36950427
Thank you both!
LVL 49

Expert Comment

by:Dale Fye
ID: 36950441
Glad to help.

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question