Memo fields truncating data

[Dazza123]

I have recently converted from an Access97 database to a SQL backend, the application is written in Access 97 forms and now uses linked ODBC tables to connect to the SQL database.

The problem I now have is that when keying in data into memo fields, the application allows users to key in as much as they want, but on saving it truncates their input to 255, the datatype for the field is set up as a VarChar 1000 chars on the SQL database.

Cheers

Dazza

 

[DJN]

Hi Dazza,
There are a couple of articles on Microsoft Knowledge base that might help. Have a look at

http://support.microsoft.com/support/kb/articles/Q103/9/98.asp?

and

http://support.microsoft.com/support/kb/articles/Q170/2/18.asp?

There are a couple of other articles that might help also.