I have a list box in my application that i would like to use in both Access 2002 and 2000. Access 2002 uses the 10.0 Object Library, Access 2000 uses the 9.0 Object Library. In Access 2002 I used ListBox.AddItem and ListBox.RemoveItem to empty and populate the control. However, these methods aren't available in Access 2000. Anyone have a good way to empty and populate a list box in both versions of Access? Thanks for your help...
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
using a list box in both Access 2002 and 2000
- Thread starter davedoop
- Start date
separated list of items.The easiest, is if you could assign a table or query as the rowsource for the list (or combo). Else you'd need to use other means of populating. If the rowsource does not exceed 2k (2048) characters, then you can use concatination:
[tt]dim s as string
do while not rs.eof
s= s & rs.fields("yourfield").value & ";"
rs.movenext
loop
me!mylist.rowsource=s[/tt]
- simple (typed not tested) sample using a recordset
For more than 2048 characters, take a look at using callback function (samples exist in the help files and should also be found by a keyword search in the access fora)
Roy-Vidar
[tt]dim s as string
do while not rs.eof
s= s & rs.fields("yourfield").value & ";"
rs.movenext
loop
me!mylist.rowsource=s[/tt]
- simple (typed not tested) sample using a recordset
For more than 2048 characters, take a look at using callback function (samples exist in the help files and should also be found by a keyword search in the access fora)
Roy-Vidar
- Status
Similar threads
- Locked
- Question
