Collapse/Hide Sections of a Form

[Ross]

I have been asked to design an access form that will have multiple sections
in it. Each section will have filter options for related data in each
section. This is in the Healthcare industry so for example:

Section One: Filters on the Customer/Employer
1.
2.
3.
4.
Section Two: Filters on the Available Programs for the Employer / Client:
1.
2.
3.
4.
Section Three: Filters in the Insured/Employee:
1. Gender
2. Geographic Location
3. Age
4. Etc

You are able to collapse, in Excel, rows in groups to hide or display the
detail using a +/-.

They would like to be able to hide or display the detail of each section on
this Access form in a similar fashion to the Excel function.

I know that I can hide the Objects/Controls with .visible = true or false.

Is there a way to hide and collapse sections of a form, perhaps with sub
forms or something like that?

Many Thanks

Ross

 

[Tom van Stiphout]

On Fri, 9 Jan 2009 04:26:06 -0800, Ross

No.
The closest you can get is with a subform within a subform. Those
records can be expanded or collapsed. This is a rather advanced topic.

Perhaps each section can be a subform on its own tab?

-Tom.
Microsoft Access MVP

 

[Dale Fye]

As a developer, and user, I hate to have to scroll down in a form that is
longer than the screen resolution, so I frequently use tab controls in this
type of situation, with a separate subform on each tab.

Enough of my soapbox. If you really want to do it as you describe, I think
you are on the right track. You could have multiple subforms, with a command
button to the left of the subform. Clicking on the button could shrink or
expand the height of a subform, but you would then need to loop through all
the controls that fall below it and change their top position appropriately.
--
HTH
Dale

email address is invalid
Please reply to newsgroup only.

 

[Peter Hibbs]

Ross,

A Flex Grid Control will probably do what you want but you will need
to write a bit of VBA code, have a look at my Flex Grid Demo program
for some examples and one example does have the facility to do what
you want.

Go to http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=180

HTH

Peter Hibbs.