Displaying text that is stored in a blob field in a SQL table

[haydenal]

I'm trying to write an access report using data in a SQL table. One of the fields in the SQL table is a blob field that contains text. I'm wondering if anyone has any suggestions on where to start to get this information to display on my report?

 

[haydenal]

Well, I've tried a CVar(FieldName) in my select query and it retrieves the first couple of lines of text for me. Trouble is, it's not retrieving all of it. Any thoughts?