[AccessD] Recordset object transposes field order

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




More information about the AccessD mailing list