Expand/Collapse

[Guest]

Is there a way to have an expand/collapse feature on an Access Form? For
instance, initially I want to show only department information, but give the
user the ability from that form to show the detail (expand -preferably
underneath on the same form) by clicking on a plus sign (+) or (...) and then
be able to hide the detail...similiar to expand/collapse in Explorer etc.

Can this be done?

Thanks!

 

[Rob Parker]

You could use a tree-view control on your form to give this capability.
However, if you do decide to do this, you will need to be reasonably
competent with VBA, since the control cannot be bound directly to data (as
with a combo-box, for example); you will need to write code to populate the
control, manipulate related information on your form, etc.

If you want some more info, here's a few links that should help:

http://msdn.microsoft.com/library/d...conscenarioviewingbibliomdbdatabaseastree.asp

http://msdn.microsoft.com/library/d...us/vbcon98/html/vbconusingtreeviewcontrol.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsmart00/html/sa00j14.asp

(watch for line-splitting on the above three links)

and

http://www.helenfeddema.com/access.htm, in particular accarch53 and
accarch103.

HTH,

Rob