Text Box Array in Access 2000

Is it possible to create a text box array in Access 2000 similar to the text box arrays available in Visual Basic?
TheClickerAsked:
Who is Participating?
 
shanesuebsahakarnConnect With a Mentor Commented:
No, you can't have a single event handler for multiple controls but you can write a single function and pass it the control name of the calling control. While it does mean you have to set the event property of each control to the call function, you do not require an event procedure for every control to do this.

There are limitations to this technique but it suffices for many operations.
0
 
shanesuebsahakarnCommented:
0
 
Arthur_WoodCommented:
No version of Access (VBA) supports control arrays, as they are supported in ful Visual Basic.

AW
0
 
Arthur_WoodCommented:
and the suggested website link is only a WEAK approximation.  The real reason for using Control Arrays is to be able to have 1 event handler, which can respond to ALL of the controls that make up the array.  Access CANNOT do anything close to that, as you must still provide separate event handlers for EACH of the controls, even if you can 'cycle' through the similar names.

txtTextName1 must have its own _Click() even handler, as must txyTextName2 and txtTextName3 and so on...there is no capability to have a SINGLE Eventhandler, that is passed the index of the specific TextBox that the user CLicked on, or raised some other even on.

AW
0
All Courses

From novice to tech pro — start learning today.