>Change it to what? And how do I do this in the View Designer? I don't see a place to select the field type
Change it to MEMO.
In View Designer click on Selected field, Then click on Properties button, in the new opened window you will see how to map it to Memo type.
Because I didn't follow whole thread maybe I missed it, but did you check FAQ #7995 - How to work with Image field type on SQL Server (binary data)?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.