Form/ListBox does not populate correctly from RecordSet

[Aaron WOLSKI]

Greetings,

Using VB/Access 2002, I am loading the contents of a file into a recordset
and trying to set it as the recordset of either a form or listbox. The
form or listbox is populated with all of the records from the recordset
but none of the values are actually visible. Interrogating the recordset
directly, I am able to see that the correct values are indeed there.

Interestingly enough, if I then move through the recordsetclone of the
form, the values appear as i 'visit' them. While this solves the problem
in the case of form, it does not sound robust and can't be applied in the
case of a listbox.

Any ideas?


Cheers,

Aaron.

 

[Art]

What is the SQL statement you use for your query or
listbox?

 

[Aaron WOLSKI]

I leave the rowsource of the listbox empty but instead set the recordset
to be an rs that I have generated programmatically. Apparently, the
ability to supply a recordset, as an alternative to specifying its
rowsource was added for Access2000.