hi viery

try this

Dim strString as String
        Dim strText as String
        strString = rs.fields("ColumnOfVarchar") 
        strText = rs.fields("ColumnOfText")


OR

Dim strString as String
        Dim strText as String
        strString = rs!"ColumnOfVarchar" 
        strText = rs!"ColumnOfText"
check the presence of Quotes in this case .i m not too sure about them.

best wishes

neeraj


-----Original Message-----
From: viery [mailto:lz7788@s...]
Sent: Friday, November 10, 2000 12:38 AM
To: professional vb
Subject: [pro_vb] text field


Hi,
When I get the data from the field of text data type using ADO,it returns
null.
Code as following(rs as RecordSet):

        Dim strString as String
        Dim strText as String
        strString = rs("ColumnOfVarchar") 
        strText = rs("ColumnOfText")

while strString returned is right,strText returns null.
Can anyone tell me how to get the data of text data type?

Best Regards.
Viery