[AccessD] Recordset object transposes field order

Hi Susan

Is it related to which column of the listbox you bind?

/gustav


> 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