Print Page | Close Window

Form_SubformAsListBox.mdb

Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Tejpal, A.D.
Forum Description: A.D. Tejpal's Library
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=99
Printed Date: 16 Dec 2017 at 9:27pm


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.

    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.

 

Download Access 2K/XP/2K3/2K7: http://www.rogersaccesslibrary.com/forum/uploads/37/Form_SubformAsListBox.zip - uploads/37/Form_SubformAsListBox.zip


-------------
--

Email: mailto:adtejpal@gmail.com - adtejpal@gmail.com



Print Page | Close Window