Memo field truncated to 256 characters.

[Sanibel]

Using VB in Access 2007 I am trying to insert up to 500 characters into a memo field. The memo field is always truncated at 256 characters. The insert has worked, data following the memo field in the same Insert statement is inserted into other fields OK.

Does anyone know what is causing the truncation.

Thanks

 

[PHV]

Does anyone know what is causing the truncation
Well, without seeing the code it's hard to say anything ...

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Andzar]

Do you use DISTINCT clause in your SQL statement ?

 

[Sanibel]

Sorry. The problem was not with my VB code but with the form that I was using to display the results. Which I have now resolved.

Thanks to those who replied anyway.