Susan Harkins
ssharkins at bellsouth.net
Thu Jul 8 08:50:12 CDT 2004
Right regarding Columm Heads, but that isn't the problem -- I think that discussion came about just through a misunderstanding of the problem. The list box is rearranging the columns. Specifically, it's transposing the first two columns. If I use a SELECT statement to populate the list box, the column order in the list box is correct. If I use a Recordset object via the Recordset property, the first two columns are flipflopped in the listbox. The Recordset itself is fine -- order is correct -- I checked it. The list box seems to do the flipping -- and Column Heads isn't involved. I just checked just to make sure and the order is wrong with Column Heads on or off. Susan H. When column heads are set to true it displays the field names, if set to false then only displays the records Paul