Microsoft access listbox selected item
Ngày đăng:
20/12/2021
Trả lời:
0
Lượt xem:
189
databasedev.co.uk - database solutions and downloads for microsoft accessMicrosoft Access Articles
GUI Design
Resources
Online Shop
Info
Microsoft Access ListboxHow to Clear a Multi-Select ListboxIf you are using a Microsoft Access listbox on your form, you can set properties to allow the database user options as to how they make selections within the list box. Show The MultiSelect property uses the following settings:
There may be occasions where you wish to clear the listbox selections, and if the list is large would like to complete this exercise automatically. To add this functionality to a command button on your form you can use the following code (replace YourCommandButtonName and YourListBoxName with the names of your button and list box): Private Sub YourCommandButtonName_Click() Dim varItm As Variant With YourListBoxName For Each varItm In .ItemsSelected .Selected(varItm) = False Next varItm End With End SubClicking the command button will now clear the listbox of any selected items.
Contact Webmaster © 2003 - 2015 databasedev.co.uk | Advertising
|