ADO Recordset returning blank fields *RESOLVED*

[BenFinkel]

Hey everyone,

I've got the following code:

Set rsMyRS = cn.execute("SELECT * FROM INDEX")
Do until rsMyRS.EOF
    Debug.Print(rsMyRs.Fields(26).Value)

     rsMyRS.MoveNext
Loop

Where cn is a connection to an SQL Server running on my computer.

The problem is that this prints out a blank, even though I can go look at the table in Ent. Manager and see that the field has a value in it. After I play around with the recordset object in the Debug window, sometimes I can get it to display the real value, but not always.

Anyone know why it would return a blank? It's not even returning NULL, but just a blank string.

Thanks!