Hi. I am working on checking and adding to an Access 2000
database. The database is being used in a Visual Basic
application. I don't know much about technology so i
would need an easy-to-understand answer, if possible.
(The database is divided into five categories.) After I
have added to or edited some entries and then go to the
program itself, the various drop down boxes are supposed
to show the entries in alphabetical order but sometimes
they are not. The names seem to be random at times.

Can anyone help? Thanks, Bobby.

if it's vb.net you can set the combobox.sorted property to true


"Bobby" <(E-Mail Removed)> wrote in message
news:0d2401c3be57$ee9e2680$(E-Mail Removed)...
> Hi. I am working on checking and adding to an Access 2000
> database. The database is being used in a Visual Basic
> application. I don't know much about technology so i
> would need an easy-to-understand answer, if possible.
> (The database is divided into five categories.) After I
> have added to or edited some entries and then go to the
> program itself, the various drop down boxes are supposed
> to show the entries in alphabetical order but sometimes
> they are not. The names seem to be random at times.
>
> Can anyone help? Thanks, Bobby.

"Bobby" <(E-Mail Removed)> wrote in message
news:0d2401c3be57$ee9e2680$(E-Mail Removed)...
.. . .
> After I have added to or edited some entries and then go to the
> program itself, the various drop down boxes are supposed
> to show the entries in alphabetical order but sometimes
> they are not. The names seem to be random at times.

If you fill the drop-downs "long-hand" (i.e. reading from database
and inserting the items in a loop), set the ComboBox's Sorted
property to True.

If the ComboBoxes are data-bound (Yuk!), add an "Order By"
clause to the SQL used to retrieve the values.

HTH,
Phill W.

* "EricJ" <ericRé(E-Mail Removed)> scripsit:
> if it's vb.net you can set the combobox.sorted property to true

This will not work with a combobox attached to a datasource.

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>

* "Bobby" <(E-Mail Removed)> scripsit:
> Hi. I am working on checking and adding to an Access 2000
> database. The database is being used in a Visual Basic
> application. I don't know much about technology so i
> would need an easy-to-understand answer, if possible.
> (The database is divided into five categories.) After I
> have added to or edited some entries and then go to the
> program itself, the various drop down boxes are supposed
> to show the entries in alphabetical order but sometimes
> they are not. The names seem to be random at times.

Give the databinding ng a try:

<news://news.microsoft.com/microsoft.public.dotnet.framework.windowsforms.databinding>

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>