Hidden & little known features in VBA and the VBE (2 Viewers)

[Pat Hartman]

Also, don't forget that if you are having to create controls on the fly, there is something very wrong with your design.

 

[MajP]

The JKP Treeview builds a tree dynamically from a Userform and MSForms controls. This is the best example of what you could do with a UserForm and cannot do in an Access form.
See discussion.

Hierarchical Data, Recursion, Tree-Views, and a Custom Class to Assist

@MajP Works perfectly on my 32 machine It's a very very nice tool, I can already see loads of ways I can make use of it Thanks I'll download it on my 64 machine later but as It doesn't use any API calls it may only be a case of reselecting the reference.

www.access-programmers.co.uk

I have built a tree using this interface with with thousands of nodes and thus thousands of controls built on the fly. This works in an Accde because as I said you can actually build on the fly not like Access where you have to go into design view (bad), and welll beyond the limitations of Access forms. The below tree loads up to 10K nodes. Every line, box, symbol, name is a control.

don't forget that if you are having to create controls on the fly, there is something very wrong with your design.

Yes if someone is building controls because there database is changing, but that is probably not what someone would be doing. More likely a nifty display of data that you cannot do in a native form.