Collapse/Hide Sections of a Form


R

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
 
Ad

Advertisements

T

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
 
D

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.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top