control arrays in access 97 1

[lora]

Hi, is there a way to create control arrays in Access? I just took a Visual Basic course and want/need to use a control array of command buttons but can't find a way to do this?

Thanks

Lora

 

[MichaelRed]

Actual control arays are not available in Ms. Access. You can approximate the process with the createcontrol method. You nees to programatically set the control parameters to the values desired, however this is veryy similar to the vb process - where you need to position the created controls.


MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over

 

[MichaelRed]

Just a brief 'thought'. In ten years of using VB and Ms. Access, I have only really ever found three "NEEDS" for a control array. Most of the suggested uses are simply a lazy avoidance of setting up a form properly.

From my personal perspective, the ONLY real need/justification for the array or createcontrol process is for a truly opne ended set of choices/responses. Otherwise the design time process of adding, sizing, placement and property settings can be done manually ONCE and fixed for the life of hte app (or at least that release). The info to create a control dynamically needs to be available at design time, otherwise the code to set up the control isn't available for the module to create it (properly) anyway.


MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over