UtterAccess.com
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
Post#1


UtterAccess VIP
Posts: 1,431
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: 415
Attached File  Image4.png ( 68.23K )Number of downloads: 257
Attached File  Image3.png ( 70.12K )Number of downloads: 178
Attached File  Image2.png ( 66.29K )Number of downloads: 146
Attached File  Image1.png ( 23.69K )Number of downloads: 90
 
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    15th December 2017 - 08:52 AM