ADO SQL Server and text dataypes [resolved]

[blindlizard]

I have something strange happening. I am pulling data from an SQL Server table. It has 5 columns.

EmployerID int(4)
ApplicationID int(4)
EmployerName varchar(255)
WorkPerformed text(16)
EndDate datetime

If I do "Select * from Employers" and then try to get the values out of a recordset, the WorkPerformed field is blank.

Debug.Print rs.Fields(0) 'Gives the value
Debug.Print rs.Fields(1) 'Gives the value
Debug.Print rs.Fields(2) 'Gives the value
Debug.Print rs.Fields(3) 'Empty String
Debug.Print rs.Fields(4) 'Gives the value

But, if I do "Select WorkPerformed From Employers"
Debug.Print rs.Fields(0) 'Gives the value

Any idea why this is happening? Even if I look in the immediates window at run time, it hows no value for WorkPerformed the first way either.