Form_ComboAndListLoopedLookUp.mdb

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 
box.

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.

Note:
        (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)
 
Download Access 2K/XP/2K3: uploads/37/Form_ComboAndListLoopedLookUp.zip