Form_ControlGroups
Sample Db - Explanatory Notes

    This sample db demonstrates handling of form controls in distinct groups in such a way that actions meant for a given group get performed across all controls belonging to that group, without having to process any loop for tackling individual controls. This functionality is achieved via class module named C_ControlGrps. Grouped controls get assigned to a collection, as instances of this class.

    Following styles of grouping are shown - covering two distinct groups in each case:
    (a) Permanent grouping via control's tag value assigned at design stage.
    (b) Dynamic grouping allowing the user to add / remove controls to any of the groups as desired, at run time.

    For current illustration, following actions performed on the groups at run time, are demonstrated:
    (a) Manipulation of default values group-wise.
    (b) Locking / unlocking of controls group-wise.
    (c) Restricting tabbing to a particular group as desired.
    (d) Hiding / un-hiding of groups as desired.
    (e) Manipulation of back colors group-wise, via slider bars for R/G/B color components.
    (f) Special effects - This involves a continuous cycle of smooth transition of shades for the back color, interspersed with periodic swapping of back colors between the two groups.

    Note:
    (a) Although the sample demonstration covers two distinct groups of controls, the class C_ControlGrps permits creation of as many separate groups of controls as required. Controls belonging to a particular group need not be contiguous.
    (b) Simultaneous action across all controls in a given group, without having to perform control-wise looping, is made feasible by invoking relevant events within the class module.

Reference required - Nothing extra.

Version - Access 2000 file format