My list box will be used to populate a form, is it possible that once the item is dble-clicked, it reverts to a different color to let the user know it has already been selected once or can the row be locked once it has been selected?
My list box will be used to populate a form, is it possible that once the item is dble-clicked, it reverts to a different color to let the user know it has already been selected once or can the row be locked once it has been selected?
There's probably a more elegant way to do it, but one alternative is to (1) load a temporary table with the list items, and a second column that represents whether they have been visited (2) load the listbox with those two columns, the second one hidden (3) use code like on this page to set the formatting of the first column elements based upon the value of the second column, (4) change the temp table and requery after each use.
http://p2p.wrox.com/access/68942-conditional-formatting-listbox-refining.html
You could do the same thing without the temp table. This method would allow you to do some analysis before you load the list box, and set values in advance depending on your application needs.
see this free video for another approach
http://www.datapigtechnologies.com/f...tboxtrick.html