Need Help From An ADO Guru

[Jules Needleman]

I am creating a recordset within my VB6 program using ADO.

After the recordset is created, I need to sort the first field of the
recordset.

If I create the field as follows:

r.Fields.Append "Field1", adChar, 25

and then sort it as follows:

r.Sort "Field1%