Text Box

[Crispy]

I have over 1500 records in my database and to try and make it easier to
find records I have added a text box which lists all the record.

However, when I add NEW records they are appended to the bottom of the
listing in the text box.....

Any way I can get the content of the text box to sort alphabetically?

Thnaks

 

[Dan Artuso]

Hi,
You must be refering to a combo or list box.
The only way to sort is to add an Order By clause to the
query that's feeding your combo or list box.

You can go into design view of the query and just sort on the appropriate field.

 

[Crispy]

Well I'll be amazed - Worked a treat.

Thanks

Hi,
You must be refering to a combo or list box.
The only way to sort is to add an Order By clause to the
query that's feeding your combo or list box.

You can go into design view of the query and just sort on the appropriate field.