Mark A Matte
markamatte at hotmail.com
Wed Jul 9 20:25:55 CDT 2003
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