Control to Expand/Collapse Continuous Form Records

[joebb3]

This one was a tough one to title...

What I am looking for is a Control (ActiveX or otherwise) to simulate expanding and contracting individual records on a form.

I don't think TreeView will fit the bill due to field lables and interface objects I use for asthetics (Filled Rectangle Backrounds and such to increase visibility and segregation of the records). Here is an example of what I'm looking for...

Example
----------
I want to turn this...

  [b][u]Name[/u]                      [u]Status[/u][/b]
+ Project 1                 In Work
+ Project 2                 Pending
...etc

into this...

  [b][u]Name[/u]                      [u]Status[/u][/b]
- Project 1                 In Work
  [u]Cost[/u]         [u]Date[/u]         [u]Number/Type of Muffins[/u]
  $20.00       1/1/11       20000/Blueberry
+ Project 2                 Pending
...etc

----------

Click the + and the record expands to show the Detailed Data.
Click the - and the Detail gets hidden.

I know that there are controls like this, you see it on web pages and such all the time, but I can't find it in my installoation of Access.

(I am on a managed network machine with only User privlages so Third Party is not an option.)

I know its a strange question, and I need it for asthetics only. My form works great as it is, but...

It could be BETTER... Ya know? I take pride the "Presentation and Usability" of my data applications... And my users appreciate it. And Tek-tips is the place I come for answers I know I can trust. =)

Thanx Everyone!
Joe
Newly MOF 4.0 Certified - Yey me!

 

[joebb3]

Someone knows a quick one line answer to this... The question is, "Who?"

I'll make it multiple choice/Fill in the blank...

Possible Answers:

A: No
B: Yes

if answer = "B" then
me!Fillin.Value = "Control Name: " & [Put Control Name Here]
end if

Thanx!

 

[dhookom]

Continuous forms will not support this type of presentation. I would think your only choice is treeview. Subdatasheets kinda do this but I don't use them.

Duane
Hook'D on Access
MS Access MVP

 

[MajP]

Subdatasheet would give you this affect, but I would not use them easier. Not very aesthetic in my opinion or easily managed. Would be similar to giving the user access to the tables.

A tree view would be close, but it provides a single line per nodes not fields. You can concatenate information. So you could get something like.

+ Name: Project 1 Status:In Work
+ Name: Project 2 Statusending
To

- Name: Project 1 Status:In Work
|- Cost: 20.00
|- Date: 1/1/11
|- Number/Type of Muffins: 20000/Blueberry
+ Name: Project 2 Statusending
...etc

 

[MajP]

Northwind wit a Treeview