Form_SubformAsListBox.mdb |
Post Reply |
Author | |
A.D. Tejpal
Microsoft MVP Joined: 30 Jun 2008 Status: Offline Points: 192 |
Post Options
Thanks(0)
Posted: 08 Jul 2008 at 11:05pm |
This sample db demonstrates use of subform as list box. Two alternatives are covered: (a) Continuous subform type list box. (b) Datasheet subform type list box. For each alternative, three styles of list box simulation are demonstrated as follows: (a) Multi-Select - Extended (b) Multi-Select - Simple (c) Single Select Selection behavior in each case is similar to that of typical normal style for the pertinent list box. Extraction of information regarding selected items is relatively more convenient as compared to a conventional list box. Subform based list box affords the added facility of convenient formatting & alignment. In datasheet based alternative, the user can even adjust the row height if required, so as to suit multi-line content. Note: (a) Overall performance regarding prompt rendering of highlight colors (based upon conditional formatting) is found to be best under Access 2003 (even better than Access 2007). (b) For multi-select (extended) list box based upon datasheet subform in versions other than A2K3 (i.e. A2K, XP, A2K7), highlight colors representing multi- selection take complete effect only when Shift key is finally released. (c) For multi-select (extended) list box based upon continuous subform, the performance in versions other than A2K7 is found to be OK (though it appears to be best in A2K3). In Access 2007 however, there is a slight time lag in rendering the highlights, though it does not wait till the shift key is finally released. |
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |