[AccessD] List box misbehaving

Charlotte Foust cfoust at infostatsystems.com
Tue Jun 17 12:10:41 CDT 2003


List boxes are almost like subforms in their behavior.  There is no
point in reporting it because it is a "feature", not a bug.  They've
behaved this way in every version of Access.

Charlotte Foust


-----Original Message-----
From: Don Elliker [mailto:delliker at hotmail.com] 
Sent: Tuesday, June 17, 2003 8:51 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] List box misbehaving


I was more intent on trying to discover why it misbehaves in the first
place - but yes, that certainly SHOULD 'fix' it - Is this reportable to
the M$ code police?
_D




"Things are only free to the extent that you don't pay for them".-Don
Elliker 
>From: "Charlotte Foust" 
>Reply-To: accessd at databaseadvisors.com 
>To: 
>Subject: RE: [AccessD] List box misbehaving 
>Date: Tue, 17 Jun 2003 09:46:16 -0700 
> 
>Have you tried setting the listbox's visible property to false when you

>make the subform visible? That is the simplest way to handle it. 
> 
>Charlotte Foust 
> 
>-----Original Message----- 
>From: Don Elliker [mailto:delliker at hotmail.com] 
>Sent: Tuesday, June 17, 2003 8:16 AM 
>To: accessd at databaseadvisors.com 
>Subject: [AccessD] List box misbehaving 
> 
> 
>Hi folks, 
>I have an XP app that is giving me the business. Bound form with a 
>tabcontrol for various memo fields. A list box with a separate data 
>source (query of another table related to bound form recordsource) An 
>invisible subform which is the same data as the mainform but in a more 
>'Excel-like' display. When they request to see the data as presented by

>the invisible form I make it visible (Ta Dah!) It overlays some of the 
>controls and the listbox is one of them. The listbox refuses to be 
>overlayed...it floats on top of the subform. I have played with 
>everything I can think of - including deleting the control and 
>compacting and repairing, then re-creating the control. It still floats

>on top (super-annoying) -I checked for requeries of the listbox. I 
>checked taborders and remnant code, there are no repaints or restore 
>commands. 
>Interestingly, I cannot get the listbox to 'move to back' nicely...it 
>flickers but stays on top of the Box it sits on - none of the other 
>controls act this way. Also, if I maximize the form...it doesn't 
>misbehave...but that, of course, is NOT the solution......??? 
>Thanks, 
>_D 
> 
> 
> 
> 
>"Things are only free to the extent that you don't pay for them".-Don 
>Elliker 
> 
> 
> 
>STOP MORE SPAM with the new MSN 8 and get 2 months FREE* 
>_______________________________________________ 
>AccessD mailing list 
>AccessD at databaseadvisors.com 
>http://databaseadvisors.com/mailman/listinfo/accessd 
>Website: http://www.databaseadvisors.com 



Tired of spam? Get advanced junk mail protection with MSN 8. 


More information about the AccessD mailing list