Problem Adding Rows to ListBox from Recordset

I have created a variant array that recieves data from a recordset using the GetRows() method of the recordset and then I am assigning the array to the .List property of the ListBox, as follows:

Please Login or Register  to view this content.

The problem I have is that if there is only one record in the recordset the ListBox is displayed empty, however if I add another record to the database both records are displayed in the ListBox?

As you can see, I've tried using the Transpose function as well as just assigning the array directly but the problem exists using either approach.

romperstomper, thanks for your reply, I've implemented that function and it works perfectly.