<html><div style='background-color:'><DIV>
<P>I've been doing this for over ten years and never had occasion to overlay a listbox...or if I did I forgot about it....I guess it gets requeried behind the scenes or someother focus grabbing event takes place. Well, I'll no better next time.<BR>Thanks,</P>
<P>_D<BR><BR>"Things are only free to the extent that you don't pay for them".-Don Elliker </P></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>>From: "Charlotte Foust" <CFOUST@INFOSTATSYSTEMS.COM>
<DIV></DIV>>Reply-To: accessd@databaseadvisors.com
<DIV></DIV>>To: <ACCESSD@DATABASEADVISORS.COM>
<DIV></DIV>>Subject: RE: [AccessD] List box misbehaving
<DIV></DIV>>Date: Tue, 17 Jun 2003 10:10:41 -0700
<DIV></DIV>>
<DIV></DIV>>List boxes are almost like subforms in their behavior. There is no
<DIV></DIV>>point in reporting it because it is a "feature", not a bug. They've
<DIV></DIV>>behaved this way in every version of Access.
<DIV></DIV>>
<DIV></DIV>>Charlotte Foust
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>-----Original Message-----
<DIV></DIV>>From: Don Elliker [mailto:delliker@hotmail.com]
<DIV></DIV>>Sent: Tuesday, June 17, 2003 8:51 AM
<DIV></DIV>>To: accessd@databaseadvisors.com
<DIV></DIV>>Subject: RE: [AccessD] List box misbehaving
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>I was more intent on trying to discover why it misbehaves in the first
<DIV></DIV>>place - but yes, that certainly SHOULD 'fix' it - Is this reportable to
<DIV></DIV>>the M$ code police?
<DIV></DIV>>_D
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>"Things are only free to the extent that you don't pay for them".-Don
<DIV></DIV>>Elliker
<DIV></DIV>> >From: "Charlotte Foust"
<DIV></DIV>> >Reply-To: accessd@databaseadvisors.com
<DIV></DIV>> >To:
<DIV></DIV>> >Subject: RE: [AccessD] List box misbehaving
<DIV></DIV>> >Date: Tue, 17 Jun 2003 09:46:16 -0700
<DIV></DIV>> >
<DIV></DIV>> >Have you tried setting the listbox's visible property to false when you
<DIV></DIV>>
<DIV></DIV>> >make the subform visible? That is the simplest way to handle it.
<DIV></DIV>> >
<DIV></DIV>> >Charlotte Foust
<DIV></DIV>> >
<DIV></DIV>> >-----Original Message-----
<DIV></DIV>> >From: Don Elliker [mailto:delliker@hotmail.com]
<DIV></DIV>> >Sent: Tuesday, June 17, 2003 8:16 AM
<DIV></DIV>> >To: accessd@databaseadvisors.com
<DIV></DIV>> >Subject: [AccessD] List box misbehaving
<DIV></DIV>> >
<DIV></DIV>> >
<DIV></DIV>> >Hi folks,
<DIV></DIV>> >I have an XP app that is giving me the business. Bound form with a
<DIV></DIV>> >tabcontrol for various memo fields. A list box with a separate data
<DIV></DIV>> >source (query of another table related to bound form recordsource) An
<DIV></DIV>> >invisible subform which is the same data as the mainform but in a more
<DIV></DIV>> >'Excel-like' display. When they request to see the data as presented by
<DIV></DIV>>
<DIV></DIV>> >the invisible form I make it visible (Ta Dah!) It overlays some of the
<DIV></DIV>> >controls and the listbox is one of them. The listbox refuses to be
<DIV></DIV>> >overlayed...it floats on top of the subform. I have played with
<DIV></DIV>> >everything I can think of - including deleting the control and
<DIV></DIV>> >compacting and repairing, then re-creating the control. It still floats
<DIV></DIV>>
<DIV></DIV>> >on top (super-annoying) -I checked for requeries of the listbox. I
<DIV></DIV>> >checked taborders and remnant code, there are no repaints or restore
<DIV></DIV>> >commands.
<DIV></DIV>> >Interestingly, I cannot get the listbox to 'move to back' nicely...it
<DIV></DIV>> >flickers but stays on top of the Box it sits on - none of the other
<DIV></DIV>> >controls act this way. Also, if I maximize the form...it doesn't
<DIV></DIV>> >misbehave...but that, of course, is NOT the solution......???
<DIV></DIV>> >Thanks,
<DIV></DIV>> >_D
<DIV></DIV>> >
<DIV></DIV>> >
<DIV></DIV>> >
<DIV></DIV>> >
<DIV></DIV>> >"Things are only free to the extent that you don't pay for them".-Don
<DIV></DIV>> >Elliker
<DIV></DIV>> >
<DIV></DIV>> >
<DIV></DIV>> >
<DIV></DIV>> >STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
<DIV></DIV>> >_______________________________________________
<DIV></DIV>> >AccessD mailing list
<DIV></DIV>> >AccessD@databaseadvisors.com
<DIV></DIV>> >http://databaseadvisors.com/mailman/listinfo/accessd
<DIV></DIV>> >Website: http://www.databaseadvisors.com
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>Tired of spam? Get advanced junk mail protection with MSN 8.
<DIV></DIV>>_______________________________________________
<DIV></DIV>>AccessD mailing list
<DIV></DIV>>AccessD@databaseadvisors.com
<DIV></DIV>>http://databaseadvisors.com/mailman/listinfo/accessd
<DIV></DIV>>Website: http://www.databaseadvisors.com
<DIV></DIV></div><br clear=all><hr>Add photos to your messages with <a href="http://g.msn.com/8HMYENUS/2749??PS=">MSN 8. </a> Get 2 months FREE*.</html>