I have an access form that is linked to a SQL server database. I have one field that is a text field that holds about what a memo (in Access) would hold. I set SQL to have this field as a text or ntext and it truncates it or gives me a “ODBC Failed Call” error. I put it as a variable varchar and I get the same thing. Any help gets all the points!
