Susan Harkins
ssharkins at bellsouth.net
Thu Jul 8 08:53:21 CDT 2004
Ordinary SELECT Gustav -- "SELECT CustomerID, CompanyName, Phone, Fax FROM Customers" Simple as pie. But remember, I'm populating the list box via the Recordset property - - and that's what seems to mess it up -- so whether it's some peculiar behavior of the Recordset object, the property, or the list box I can't tell. Susan H. Hi Susan Oh, sorry, missed that point. I have no idea - never observed that. What does your Select statement look like? "Select * .." or "Select Company, Customary .." /gustav > 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