Text Box

  • Thread starter Thread starter Crispy
  • Start date Start date
C

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
 
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.
 
Well I'll be amazed - Worked a treat.

Thanks


Dan Artuso said:
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.
Click to expand...
 
Back
Top