X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Using A Continuous Type Subform In Place Of A List Box Control., Any Version    
Peter Hibbs
post Jan 18 2014, 09:42 AM

UtterAccess VIP
Posts: 1,589
Joined: 17-June 10
From: Dorset. UK.

The standard List Box control that comes with all versions of Access is very useful for providing a list of items on a form and is generally easy and quick to set up. It also has the facilities to select/deselect items on the list, select multiple rows, read which row/s are currently highlighted and so on, however, it has very limited formatting facilities for text alignment, color coding, graphics images, etc. The accompanying (Access 2003) demo database shows a method of providing a better looking List Box by using a standard Continuous type Subform control instead and using this method allows the developer to provide more facilities than the normal list box, as shown in the screen shots below. The demo also provides a number of VBA procedures which simulate the facilities of a List box, which can be used with the subform version to select, de-select, read, etc the data in the form. A pdf document describes the facilities and VBA code procedures in more detail.
eter Hibbs.
Attached File(s)
Attached File  Alt_List.zip ( 426.14K )Number of downloads: 460
Attached File  Image4.png ( 68.23K )Number of downloads: 273
Attached File  Image3.png ( 70.12K )Number of downloads: 189
Attached File  Image2.png ( 66.29K )Number of downloads: 155
Attached File  Image1.png ( 23.69K )Number of downloads: 94
Go to the top of the page

Custom Search
RSSSearch   Top   Lo-Fi    23rd October 2018 - 12:42 AM