bchacc at san.rr.com
bchacc at san.rr.com
Thu Jul 8 09:17:26 CDT 2004
Susan: A workaround I'd use would be to loop thorugh the recordset seting the fields into a string in the order you want separated by semicolons and then set the row source of the list box to that string. I do combo boxes that way. Rocky Original Message: ----------------- From: Susan Harkins ssharkins at bellsouth.net Date: Thu, 08 Jul 2004 09:42:30 -0400 To: accessd at databaseadvisors.com Subject: RE: [AccessD] Recordset object transposes field order Column Heads should simply display the column names in the first row -- not rearrange the columns. The SELECT statement retrieves Customary and Company Name -- in that order, but the list box displays Company Name first. That's what I meant by "transposed." Susan H. Hi Susan Ehh ... That's by design ... What else would you suggest a property of this name should address? /gustav -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -------------------------------------------------------------------- mail2web - Check your email from the web at http://mail2web.com/ .