Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > MS Access MVP Libraries > Tejpal, A.D.
  New Posts New Posts RSS Feed - Form_SubformAsListBox.mdb
  FAQ FAQ  Forum Search   Events   Register Register  Login Login


Please consider donating $1 per sample downloaded, (find out why here)

Form_SubformAsListBox.mdb

 Post Reply Post Reply
Author
Message
A.D. Tejpal View Drop Down
Microsoft MVP
Microsoft MVP


Joined: 30 Jun 2008
Status: Offline
Points: 192
Post Options Post Options   Thanks (0) Thanks(0)   Quote A.D. Tejpal Quote  Post ReplyReply Direct Link To This Post Topic: Form_SubformAsListBox.mdb
    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: uploads/37/Form_SubformAsListBox.zip
--

Email: adtejpal@gmail.com
Back to Top
Sponsored Links


Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down