Hiding fileds and labels and moving others

[Guest]

Hi,

I am creating a datbase that has a form which ids pretty much like an excel
spreadsheet. It is a continuous form which has lots of colums across the
top. The columns are effectively in groups, what i want to be able to do is
say x number of fields hide, i then want any fields and labels that were
after them on the form to move up so there is no gap. Like the hide on an
excel spreadsheet. I have worked out a crude way by storing left hand
locations adding widths and movin every field and label indivdually but this
will take alot of code and if at any time another column was added then it
wuold all break. Is there a simple way to hide a section on a form so that
it effectively goes to width 0 and everything after it moves up?

I am not sure whether there is an easy solution or if there is one at all
for this but i would appreciate any ideas,

Cheers

Danny

 

[Amy Blankenship]

Why not break it into several forms and place each on a tab control?

 

[Guest]

I have 7 seven groups and i may want to hide say group 1 3 and 5 but show the
others, if i did a tab then i could only show one group on each tab. Is there
no way to hide a certain section on a form on make its width 0 while moving
everythign after it up?

Cheers

Danny