[AccessD]ComboBox Values

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



More information about the AccessD mailing list