mass set form hidden property

N

NKTower

I've got 150+ forms.subforms in an internal application. I'd like to set
them all to hidden just to clean up the FORMS page of the database window. I
know about MDE, that's not what I want. Nor do I relish manually
right-clicking each one, selecting properites, clicking HIDDEN and OK for
each. This isn't a 'security' issue, I just want to get stable forms 'out of
sight'. I suspect that I can use VBA to loop through something (Documents
container?) and set a property, but don't know where it is. Thanks.
 
D

Damon Heron

In Access 2007, you can shift rt-clik to highlight all of your forms, then
select "hide in this group". After that, un-select the show hidden property
on the menu.
I forget if this is possible with earlier versions.

Damon
 
N

NKTower

Unfortunately, I'm stuck with Access 2003 on this one. Shift Right-Click does
give a fly-out menu with Add to Group - but they would still have to be done
one-at-a-time.

I suspect that I should be ablt to get at it by manipulating the forms as
"Documents" within VBA, but haven't found it yet. I'll keep looking, but
it's low priority.

Thanks
 
Top