K
Ken Wienecke
This is not a bug, per se, but a very annoying UI issue that I have seen in
all later versions of Access. I am currently running Access 2003
(11.6566.8107) SP2.
I have a form with one or more listboxes. The listboxes have multiple
unattached labels across their top edges which highlight the columns in the
controls. The form has other unnattached labels with instruction text. The
listboxes in question here have a Data Source which is an SQL statement or
defined query. The controls work just fine, just as my VBA programming
expects.
Now the fun. When the form is running normally, and I merely mouse-over ANY
LABEL ON THE FORM, one, more or even all of the listsbox controls matching
the description above either refresh, repaint or actually requery themselves
(I can't tell which, except that it takes a noticable period of time and the
listbox content flashes)! I don't have to click anything. The
refresh/repaint/requery happens once when the cursor moves into the area of a
label, and once when it moves out of the area. This symptom does NOT occur
in listboxes filled by code or item values, only a query or SELECT statement.
The behavior doesn't change the value of the listbox or negatively impact
operation of the control in any other way.
This listbox can have Enabled = False, and it still happens. The label can
be attached or unattached and it still happens. Adjoining labels act in
unison, provoking this action once when the cursor enters and once with it
leaves their combined areas. Labels anywhere on the form will trigger this
behavior. When the listboxes are part of a tabbed page, only those on the
same tabbed page exhibit the behavior.
I see this behavior in a number of databases I've built, not just the one in
question. I have repaired, compacted, experimented with attached and
unattached labels and tried to trap the behavior via event code, all to no
avail. Maybe it's some characteristic of the underlying query, but it seems
unlikely. Maybe it's related to the form repainting Access does under the
skin. Beats me.
I have Googled every keyword I can think of, and I can find no mention of
this behavior, but I've seen it in every Access platform since 97 (and on
multiple computers). I'm finally frustrated enough to send out this appeal.
All the "activity" is a real distraction to users who move the cursor through
labels from control to control (ie., everybody). This behavior doesn't break
anything...it just makes my apps a bear to use. I tend to use interlocking
listboxes to display data views because they take less screen real estate.
all later versions of Access. I am currently running Access 2003
(11.6566.8107) SP2.
I have a form with one or more listboxes. The listboxes have multiple
unattached labels across their top edges which highlight the columns in the
controls. The form has other unnattached labels with instruction text. The
listboxes in question here have a Data Source which is an SQL statement or
defined query. The controls work just fine, just as my VBA programming
expects.
Now the fun. When the form is running normally, and I merely mouse-over ANY
LABEL ON THE FORM, one, more or even all of the listsbox controls matching
the description above either refresh, repaint or actually requery themselves
(I can't tell which, except that it takes a noticable period of time and the
listbox content flashes)! I don't have to click anything. The
refresh/repaint/requery happens once when the cursor moves into the area of a
label, and once when it moves out of the area. This symptom does NOT occur
in listboxes filled by code or item values, only a query or SELECT statement.
The behavior doesn't change the value of the listbox or negatively impact
operation of the control in any other way.
This listbox can have Enabled = False, and it still happens. The label can
be attached or unattached and it still happens. Adjoining labels act in
unison, provoking this action once when the cursor enters and once with it
leaves their combined areas. Labels anywhere on the form will trigger this
behavior. When the listboxes are part of a tabbed page, only those on the
same tabbed page exhibit the behavior.
I see this behavior in a number of databases I've built, not just the one in
question. I have repaired, compacted, experimented with attached and
unattached labels and tried to trap the behavior via event code, all to no
avail. Maybe it's some characteristic of the underlying query, but it seems
unlikely. Maybe it's related to the form repainting Access does under the
skin. Beats me.
I have Googled every keyword I can think of, and I can find no mention of
this behavior, but I've seen it in every Access platform since 97 (and on
multiple computers). I'm finally frustrated enough to send out this appeal.
All the "activity" is a real distraction to users who move the cursor through
labels from control to control (ie., everybody). This behavior doesn't break
anything...it just makes my apps a bear to use. I tend to use interlocking
listboxes to display data views because they take less screen real estate.