PC Review


Reply
Thread Tools Rate Thread

ComboBox Sort

 
 
=?Utf-8?B?RGVubmlz?=
Guest
Posts: n/a
 
      20th Mar 2005
Whenever I change an item in my combobox, it doesn't resort the items. If I
add an item, then it sorts ok. Is this normal?
--
Dennis in Houston
 
Reply With Quote
 
 
 
 
Herfried K. Wagner [MVP]
Guest
Posts: n/a
 
      20th Mar 2005
"Dennis" <(E-Mail Removed)> schrieb:
> Whenever I change an item in my combobox, it doesn't resort the items. If
> I
> add an item, then it sorts ok. Is this normal?


I am able to reproduce this behavior. Quick workaround:

\\\
With Me.ComboBox1
.Items(2) = "ZZZZ"
.Sorted = False
.Sorted = True
End With
///

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>

 
Reply With Quote
 
=?Utf-8?B?RGVubmlz?=
Guest
Posts: n/a
 
      20th Mar 2005
Thanks. I thought I'd tried that but apparently I only reset the sorted
property True and didn't set it to False first.

"Herfried K. Wagner [MVP]" wrote:

> "Dennis" <(E-Mail Removed)> schrieb:
> > Whenever I change an item in my combobox, it doesn't resort the items. If
> > I
> > add an item, then it sorts ok. Is this normal?

>
> I am able to reproduce this behavior. Quick workaround:
>
> \\\
> With Me.ComboBox1
> .Items(2) = "ZZZZ"
> .Sorted = False
> .Sorted = True
> End With
> ///
>
> --
> M S Herfried K. Wagner
> M V P <URL:http://dotnet.mvps.org/>
> V B <URL:http://classicvb.org/petition/>
>
>

 
Reply With Quote
 
Herfried K. Wagner [MVP]
Guest
Posts: n/a
 
      20th Mar 2005
"Dennis" <(E-Mail Removed)> schrieb:
> I thought I'd tried that but apparently I only reset the sorted
> property True and didn't set it to False first.


That's what I tried too :-)...

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sort ComboBox Peter Microsoft C# .NET 4 7th Feb 2006 02:53 PM
Sort Combobox List T De Villiers Microsoft Excel Programming 1 21st Jan 2006 02:53 PM
Sort By A Combobox Filter David Whitaker Microsoft Access Form Coding 1 4th Jun 2004 01:16 AM
combobox sort David Whitaker Microsoft Access Form Coding 1 2nd Jun 2004 10:04 PM
Sort in a ComboBox Tiffany Microsoft Access VBA Modules 2 24th Sep 2003 09:32 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:50 AM.