Another 2007 bug (Access 2007)

Topic

New Reply

Here is an Access2007 bug I just found.

I provide a “Select All” button to allow users to select all lines in a multi-select listbox. The code is very simple, as in this example:
————————————–
Dim N As Integer

For N = 0 To lstAttendees.ListCount – 1
lstAttendees.Selected(N) = True
Next N
——————————–

This has worked in all versions of Access until Access2007!

In Access2007, if the listbox has the “Column Headers” property set to True, it will “select” the header row also! Previous versions apparently did not allow the Selected property of the header row to be set.

Reply | Quote

Replies

Yep – see A2007: Interesting list box bug. It mentions that the bug has been reported to Microsoft, and a clever workaround.

Reply | Quote

I wish Microsoft had a comprehensive list of all reported bugs that they published. I checked their website and found some A2007 issues, but this one wasn’t one of them. I also checked a few other websites, and no-one had mentioned this one either. Unfortunately, when someone says “This has been reported to Microsoft”, I don’t exactly know what that means. Do they have some of “official” method for doing so unavailable to the rest of us?

Reply | Quote

Some software makers are upfront about bugs and problems they know about, but Microsoft has always been more reticent.

Tony Toews is a Microsoft MVP for Access, so he does have a direct way of contacting the Microsoft Access development team.

Reply | Quote