
rtf file, it opens, correctly formatted, in WordPad. It is just text with formatting: bold, underline, different font colors, etc. Note that these are not pictures embedded in the field. Or do I have to open the connection and pull the data programmatically using an ADO connection in VBA? But I can find no option that seems related. So I suspect this probably has something to do with some ODBC DSN parameter that must be configured to recognize BLOB fields as Long Text. But even then, I cannot change the type of a text box bound to this field from Plain Text to Rich Text. I go into design view of my query, right-click anywhere in the field, go to Properties, and set Text Format to Rich Text.

And of course, because it is an ODBC-linked table,

When I make my ODBC connection to the table, though, the BLOB fields appear formatted as Short Text.

So I already know that, in order to format a text box as Rich Text, the underlying data source must be a Memo field (Long Text in Access 2013).īut I need to retrieve and display some DB2 BLOB fields, which I believe roughly correspond to Long Text.
