Susan Harkins
harkins at iglou.com
Wed Jul 9 20:58:03 CDT 2003
Have you tried any of the mouse events? I'm not sure there's an appropriate one, but... Susan H. > Darren, > > Correct...it is in DropDown Mode...but I can't get the value when the mouse > changes the highlighted value...only when the arrow keys are used to move to > the next value...I will let you know if I figure the mouse out...but for > now...I used the onchange event and the .SelText property...ex: > > Private Sub Combo0_Change() > Me!Text2 = Me!Combo0.SelText > End Sub > > > Hope it helps... > > Mark > > >From: "Darren DICK" <d.dick at uws.edu.au> > >Reply-To: Access Developers discussion and problem > >solving<accessd at databaseadvisors.com> > >To: "Access Developers discussion and problem > >solving"<accessd at databaseadvisors.com> > >Subject: Re: [AccessD]ComboBox Values > >Date: Thu, 10 Jul 2003 10:58:02 +1000 > > > >Hi Mark > >As a matter of interest how did you achieve this? > >You mention SelText. But where did you place the code? > >I assume by the way you mean when a combo is in drop down mode (As Drew > >suggested) > >and the user runs the mouse up and down the drop down list (without > >clicking) the item under the mouse cursor > >actually gets 'highlighted'. > >Is it this 'highlighted' value you have been able to get? > >Many thanks in advance > > > >Darren > > > > > >----- Original Message ----- > >From: "Mark A Matte" <markamatte at hotmail.com> > >To: <accessd at databaseadvisors.com> > >Sent: Thursday, July 10, 2003 6:45 AM > >Subject: RE: [AccessD]ComboBox Values > > > > > > > Thats correct...thanks Drew. I got it using the .SelText property. > > > > > > Thanks to all. > > > > > > Mark A. Matte > > > > > > > > > >From: Drew Wutka <DWUTKA at marlow.com> > > > >Reply-To: Access Developers discussion and problem > > > >solving<accessd at databaseadvisors.com> > > > >To: "'Access Developers discussion and problem solving'" > > > ><accessd at databaseadvisors.com> > > > >Subject: RE: [AccessD]ComboBox Values > > > >Date: Wed, 9 Jul 2003 13:25:12 -0500 > > > > > > > >Actually, I think the post is about what item is highlighted when the > >combo > > > >box is in DropDown mode. > > > > > > > >Drew > > > > > > > >-----Original Message----- > > > >From: Wortz, Charles [mailto:CWortz at tea.state.tx.us] > > > >Sent: Wednesday, July 09, 2003 12:22 PM > > > >To: Access Developers discussion and problem solving > > > >Subject: RE: [AccessD]ComboBox Values > > > > > > > > > > > >Yes. Now it is possible the original questioner does not know where > > > >that value is stored and that may be what he really wants to know. But > > > >that is not what he asked for. In either case, the value of the bound > > > >column of the highlighted row is stored in the .selected property. You > > > >can test if what I am saying is correct by displaying the .selected > > > >property in the OnChange event. > > > > > > > >Charles Wortz > > > >Software Development Division > > > >Texas Education Agency > > > >1701 N. Congress Ave > > > >Austin, TX 78701-1494 > > > >512-463-9493 > > > >CWortz at tea.state.tx.us > > > > > > > > > > > > > > > >-----Original Message----- > > > >From: Susan Harkins [mailto:harkins at iglou.com] > > > >Sent: Wednesday 2003 Jul 09 12:08 > > > >To: Access Developers discussion and problem solving > > > >Subject: Re: [AccessD]ComboBox Values > > > > > > > >If that's the case, the "highlighted" value is already known, right? > > > > > > > >Susan H. > > > > > > > > > > > > > Susan, > > > > > > > > > > The only time there is a difference that I know about is when there > >is > > > > > > > > > a default value that is highlighted before any selection is made. > >So > > > > > a highlighted value is either a default value that he should know or > >a > > > > > > > > > selected value that he should know. > > > > > > > > > > Charles Wortz > > > > > -----Original Message----- > > > > > From: Susan Harkins [mailto:harkins at iglou.com] > > > > > Sent: Wednesday 2003 Jul 09 11:29 > > > > > To: Access Developers discussion and problem solving > > > > > Subject: Re: [AccessD]ComboBox Values > > > > > > > > > > What's the difference between a highlighted item and a selected > >item? > > > > > > > > > > Susan H. > > > > > > > > > > > > > > > > Hello All, > > > > > > > > > > > > In A97 is there a way to tell the value of what is highlighted in > >a > > > > > > combo box before you actually select it? > > > >_______________________________________________ > > > >AccessD mailing list > > > >AccessD at databaseadvisors.com > > > >http://databaseadvisors.com/mailman/listinfo/accessd > > > >Website: http://www.databaseadvisors.com > > > >_______________________________________________ > > > >AccessD mailing list > > > >AccessD at databaseadvisors.com > > > >http://databaseadvisors.com/mailman/listinfo/accessd > > > >Website: http://www.databaseadvisors.com > > > > > > _________________________________________________________________ > > > The new MSN 8: advanced junk mail protection and 2 months FREE* > > > http://join.msn.com/?page=features/junkmail > > > > > > _______________________________________________ > > > AccessD mailing list > > > AccessD at databaseadvisors.com > > > http://databaseadvisors.com/mailman/listinfo/accessd > > > Website: http://www.databaseadvisors.com > >_______________________________________________ > >AccessD mailing list > >AccessD at databaseadvisors.com > >http://databaseadvisors.com/mailman/listinfo/accessd > >Website: http://www.databaseadvisors.com > > _________________________________________________________________ > The new MSN 8: advanced junk mail protection and 2 months FREE* > http://join.msn.com/?page=features/junkmail > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > >