Form_ComboAndListLoopedLookUp.mdb |
Post Reply |
Author | |
A.D. Tejpal
Microsoft MVP Joined: 30 Jun 2008 Status: Offline Points: 192 |
Post Options
Thanks(0)
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 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.
|
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |