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_ComboAndListLoopedLookUp.mdb
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

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


 Post Reply Post Reply
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_ComboAndListLoopedLookUp.mdb
    Posted: 09 Jul 2008 at 10:39pm
The sample db demonstrates a simulated combo box where the selected item is 
always displayed in the middle row of drop down list. A list box acts as the drop 
down list, while a text box combined with command button is used in lieu of combo 

This feature can be useful where the user desires to see at a glance, the available 
choices just before the selected item as well, without having to scroll back. (In a 
normal combo box, selected item appears at the very top, hiding the available 
choices prior to it).

The drop down list has a loop feature as well, so that even if the selected item 
happens to be at the very end, the display is extended by continuing with first few 
items after the last item (or last few items before the first item), giving the effect of 
an endless display.

Auto-expand and Not-In-List features (permitting the user to add new items if 
desired) are also provided. During auto-expand action, matching selection 
continues to occupy the middle row of drop down list.

        (1) If Not-In-List feature is to be disabled, set form level global constant named 
             ForceInList to "N".
        (2) This sample has 9 displayable rows in the list box. If this value is required 
             to be changed in view of different combination of height and font for the 
             list box, value of public constant named RowsMax  in general module 
             should be modified suitably.
        (3) Stand-alone list box with endless looped list, always positioning the 
             selected item at the middle row, is also displayed.

Access Versions 2K/XP/2K3 (Access 2K File Format)


Back to Top
Sponsored Links

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

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