Print Page | Close Window


Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Tejpal, A.D.
Forum Description: A.D. Tejpal's Library
Printed Date: 27 Jan 2021 at 11:12am
Software Version: Web Wiz Forums 12.03 -

Topic: Form_SubformAsListBox.mdb
Posted By: A.D. Tejpal
Subject: Form_SubformAsListBox.mdb
Date 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.

    (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 


Download Access 2K/XP/2K3/2K7: - uploads/37/


Email: -

Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.03 -
Copyright ©2001-2019 Web Wiz Ltd. -